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

  • Thread starter Thread starter Cluce
  • Start date Start date
C

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
 
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
Click to expand...

=LEFT(A1)&B1
--ron
 
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
 
Hi,

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

Mike
 
Back
Top