ExcelBanter - Joining letters from different cells

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Joining letters from different cells (https://www.excelbanter.com/excel-worksheet-functions/49023-joining-letters-different-cells.html)

Lance

Joining letters from different cells

Hi All,

Is there a formula to join the following characters to create the
example shown below.

B2 C2 D2 (End Result)
JORDAN MIKE JORDAN JORDAN M

I'm getting close with the formula below, but can't work it out.
=LEFT(C1,50)& MID(D1,FIND(" ",D3)+ 1,1)

Thanks,

cRIMSOn

JE McGimpsey

One way:

D2: =B2 & " " & LEFT(C2, 1)

In article . com,
"Lance" wrote:

Hi All,

Is there a formula to join the following characters to create the
example shown below.

B2 C2 D2 (End Result)
JORDAN MIKE JORDAN JORDAN M

I'm getting close with the formula below, but can't work it out.
=LEFT(C1,50)& MID(D1,FIND(" ",D3)+ 1,1)

Thanks,

cRIMSOn

Lance

You are a Legand.. Thank you very much ; )

David McRitchie

Incidentally in the US when placing the surname first we would
normally place a comma and space after the surname, to show that
the order is different.

D2: =B2 & ", " & LEFT(C2, 1)

"Lance" wrote in reply to J.E. McGimpsey...
You are a Legend .. Thank you very much ; )

All times are GMT +1. The time now is 05:05 PM.