| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Spliting a cell
Hi all,
I have a full name in cell A1. I want to put the first name in cell A2 and the Last name in cell A3. The names are present traditionally: Jim Smith. Can you help me out? Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Spliting a cell
You can try menu DataText to ColumnsDelimiter and select space to split
this to two columns. If you are looking for formulas try the below In B1 =TRIM(LEFT(A1,FIND(" ",A1)-1)) In C1 =TRIM(MID(A1,FIND(" ",A1)+1,LEN(A1))) If this post helps click Yes --------------- Jacob Skaria "Jim" wrote: Hi all, I have a full name in cell A1. I want to put the first name in cell A2 and the Last name in cell A3. The names are present traditionally: Jim Smith. Can you help me out? Thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Spliting a cell
With error handling
In B1 =TRIM(LEFT(A1,FIND(" ",A1 & " ")-1)) In C1 =TRIM(MID(A1,FIND(" ",A1 & " ")+1,LEN(A1))) If this post helps click Yes --------------- Jacob Skaria "Jacob Skaria" wrote: You can try menu DataText to ColumnsDelimiter and select space to split this to two columns. If you are looking for formulas try the below In B1 =TRIM(LEFT(A1,FIND(" ",A1)-1)) In C1 =TRIM(MID(A1,FIND(" ",A1)+1,LEN(A1))) If this post helps click Yes --------------- Jacob Skaria "Jim" wrote: Hi all, I have a full name in cell A1. I want to put the first name in cell A2 and the Last name in cell A3. The names are present traditionally: Jim Smith. Can you help me out? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| spliting a cell into more cells | Excel Discussion (Misc queries) | |||
| Spliting a cell | Excel Discussion (Misc queries) | |||
| Spliting a cell with multiple entries into seperate rows | Excel Discussion (Misc queries) | |||
| Spliting a cell into two parts | Excel Discussion (Misc queries) | |||
| Spliting the contents of a cell to other cells | Excel Worksheet Functions | |||
Linear Mode
