Hi,

The & symbol means concatenate and while MID does work i would still
recommend LEFT for removing the leftmost character.

Mike

"Cluce" wrote:

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