Extracting First Letter

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

crackle - 10 Jan 2007 02:21 GMT

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

Signature

Thanks

Reply to this Message

Max - 10 Jan 2007 02:44 GMT

Perhaps this might suffice

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

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

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

Reply to this Message

crackle - 10 Jan 2007 03:18 GMT

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.

Signature

Thanks

> Perhaps this might suffice
>
[quoted text clipped - 3 lines]
> > Can anyone help, i'm trying to extract the first letter of each word within
> > any given phrase. I'm using excel 2003

Reply to this Message