View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Khoshravan Khoshravan is offline
external usenet poster
 
Posts: 211
Default In excel, how do we pull the first letter from words in a sentence

Not sure exactly about your question, but in Excel with "Left" command you
can choose any number of characters from beginning of a sentence.
With combination of "Left" and "Middle" and the space between words in a
sentence you can pull out the first char. of words in a sentence.

"Deepak" wrote:

I need to assign codes to words for e.g. Product Master would need a code
like "PM"