G
Guest
Can anyone help, i'm trying to extract the first letter of each word within
any given phrase. I'm using excel 2003
any given phrase. I'm using excel 2003
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Guest
Perhaps this might suffice
With text running in A1 down
In B1: =LEFT(TRIM(A1),1)
Copy down
With text running in A1 down
In B1: =LEFT(TRIM(A1),1)
Copy down
G
Guest
Sorry Max, let me be more specific, eg. Lets say I have the phrase "The quick
brown fox jumped over the moon" located in A1, now I want extract the first
letter of each word within that phrase, or any phrase I might put in A1.
What I am using it for is first letter memory techniques of any given phrase.
brown fox jumped over the moon" located in A1, now I want extract the first
letter of each word within that phrase, or any phrase I might put in A1.
What I am using it for is first letter memory techniques of any given phrase.
G
Guest
Thanks Mate
works a treat. Don't know how it does it but is sure has saved me helluva
heaps of time.
works a treat. Don't know how it does it but is sure has saved me helluva
heaps of time.
G
Guest
You're welcome. I'm sure Ron would be pleased that his UDF was a great fit
here !
here !