Hi Emily

LEFT(A1)&LEFT(B1)&LEFT(C1)

Without specifying the number of characters, the default is 1

--
Regards

Roger Govier


"Emily G" <Emily wrote in message
...
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!