concatenate parts of a cell

[fred.preston]

Is there a way to concatenate parts of a cell. For example the first
three letters of one cell combined with the first three letters of
another cell.
A1 B1 C1
John Doe would become Jodo

 

[John W.]

Suppose you put this in cell C1:

=LEFT(A1,3)&LOWER(LEFT(B1,1))&RIGHT(LEFT(B1,3),2)

This assumes, as in your example, that the first letter of the last
name should not be capitalized when creating the concatenation.

John W.

 

[fred.preston]

Thanks for your response John W.
The above formula didn't work but it pointed me in the right direction.

I used the formula below and it worked.
=LEFT(A4,3)&RIGHT(B4,2)&RIGHT(C4,2)
Thanks.