Extracting First Letter

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
 
G

Guest

Perhaps this might suffice

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.
 
G

Guest

Thanks Mate

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Convert word into numbers and back 4
How to type each letter of the alphabet automatically in a specific color in Word? 0
Need help making the first letter of Cell capitol 1
How to use/extract only a portion of a field 2
Setting up TrueNAS frustration 4
Extracting First Name 12
Access to split First and Last name 0
Create Acronym (Extract first letter of each word) 16

Top