Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
name separation
how do i separate a single cell name "Doe, John" into two separate cells?
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
name separation
Hi,
text in a1 First part =LEFT(A1,FIND(",",A1,1)-1) Second part =TRIM(MID(A1,FIND(",",A1,1)+1,LEN(A1))) Mike "Help with Cell question" wrote: how do i separate a single cell name "Doe, John" into two separate cells? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
name separation
Assuming 'Doe, John' is in Cell A1...
=LEFT(A1,FIND(", ",A1)-1) equals 'Doe' =RIGHT(A1,LEN(A1)-FIND(", ",A1)-1) equals 'John' -- Hope this helps. If this post was helpfull, please remember to click on the ''''YES'''' button at the bottom of the screen. Thanks, Gary Brown "Help with Cell question" wrote: how do i separate a single cell name "Doe, John" into two separate cells? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
name separation
If you are asking this because you have a column of names like that in
single cells, you can select all the names in the column, click Data/Text To Columns on Excel's menu bar; select the Delimited option on the Step 1 dialog page and click Next; put a check mark in the Space, Comma and "Treat consecutive delimiters as one" check boxes and then click Finish. Rick "Help with Cell question" <Help with Cell wrote in message ... how do i separate a single cell name "Doe, John" into two separate cells? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mean separation by LSD value | Excel Worksheet Functions | |||
Value separation and then adding | Excel Worksheet Functions | |||
Cell Separation | Excel Worksheet Functions | |||
Decimals separation "." and "," | Excel Worksheet Functions | |||
Decimals separation by . or , | Excel Discussion (Misc queries) |