name separation
how do i separate a single cell name "Doe, John" into two separate cells?
|
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? |
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? |
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? |
All times are GMT +1. The time now is 08:47 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com