Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
You are a Legand.. Thank you very much ; )
|
#4
|
|||
|
|||
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 ; ) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i protect cells in a shared worksheet | Excel Discussion (Misc queries) | |||
Conditional formatting...cont. from 9/25 | Excel Discussion (Misc queries) | |||
Display first, second, etc Nonblank Cells in a Range | Excel Worksheet Functions | |||
copy & paste spreadsheet cells from excel to outlook to excel | Excel Discussion (Misc queries) | |||
Finding Numbers with Cells that also contain letters | Excel Discussion (Misc queries) |