formula that strips the first letter of the first name in a cell

[Cluce]

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

 

[Mike H]

Try

=LEFT(A1,1)&B1

Mike

 

[Ron Rosenfeld]

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

=LEFT(A1)&B1
--ron

 

[Cluce]

Thanks. This works too.

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

 

[Pete_UK]

Try this:

=LEFT(A1,1) & B1

or this if you want a space between the initial and the surname:

=LEFT(A1,1) & " " & B1

Hope this helps.

Pete

 

[Mike H]

Hi,

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

Mike