Formula Help

[Robert Ayers]

Here is what I am trying to do. Can anyone help?

Cell A1 has this for the contents Adam
Cell B1 has this for the contents Smith

I would like cell C1 to contain his 2 initials, I can do this but it
takes an additional step, I would like to use the left function to
extract the first character from both cells A1 and B, then
concatenate the two characters into cell C1. I just cant seem to get
this to work together without using 3 formulas. Here is what I have
tried.

=CONCATENATE,LEFT(A1,1),LEFT(F5,1)

Any suggestions?

Thanks in advance

Robert

 

[Gromit]

If I inderstand you right, try this in cell C1

=LEFT(A1) & LEFT(B1)

Graham

 

[Robert Ayers]

It worked perfectly!

Thanks

Robert