View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Emily G Emily G is offline
external usenet poster
 
Posts: 1
Default Using the LEFT formula for multiple cells

I'm going nuts trying to figure out if I have mulitple cells, and I want to
take the first character of each text string in each cell into one cell what
do I use with the LEFT formula?

Example.

A1 = Hi
B1 = Ouch
C1 = What

D=HOW or =LEFT(A1,1),(B1,1),(C1,1)

Nothing I'm trying is working :(

Your help is appreciated!