Thanks. This works too.

=CONCATENATE(MID(A2,1,1),B2)

"Mike H" wrote:

Try

=LEFT(A1,1)&B1

Mike

"Cluce" wrote:

I dont know if this can be done but how can I do this....
let's say
in
cell A1 I have the value "John"
cell B1 I have the value "Smith"

Can I write a formula to create this in cell C1 "JSmith"
I guess it would be something like this = ????? + B1