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

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

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

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

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

On Tue, 23 Jun 2009 07:47:02 -0700, 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

=LEFT(A1)&B1
--ron

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

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

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

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