Extracting First Letter

[crackle]

Can anyone help, i'm trying to extract the first letter of each word within
any given phrase. I'm using excel 2003

 

[Max]

Perhaps this might suffice

With text running in A1 down
In B1: =LEFT(TRIM(A1),1)
Copy down

 

[crackle]

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.

 

[crackle]

Thanks Mate

works a treat. Don't know how it does it but is sure has saved me helluva
heaps of time.

 

[Max]

You're welcome. I'm sure Ron would be pleased that his UDF was a great fit
here !