Extracting First Letter

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
Perhaps this might suffice

With text running in A1 down
In B1: =LEFT(TRIM(A1),1)
Copy down
 
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.
 
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

How to type each letter of the alphabet automatically in a specific color in Word? 0
Excel Convert word into numbers and back 4
Auto fill not working 2
Counting and deleting 7
Extract specific information from the body of outlook mail to an Excel File using VBA 0
Access to split First and Last name 0
Create Acronym (Extract first letter of each word) 16
Extract all letters from a cell sentence 5

Back
Top