| 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 |
| 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) | |||
Threaded Mode
