I have a very large sheet that has over 68,000 names that are all in one column. First and last separated by a comma. Is there any way to separate these out into two columns by first and last name?
I have a very large sheet that has over 68,000 names that are all in one column. First and last separated by a comma. Is there any way to separate these out into two columns by first and last name?
One way, if the column next to the names is blank...
Select the column (with the names in it).
Click Data > Text to Columns.
Then Select Delimited and click next.
Check the Comma Box and click next.
Then click finish
1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.
Tom
if there are only two names seperated by a comma
click on the column - then use Data > Text to columns
choose delimited > next
choose , > next
that should do what you asked
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Let's assume the names are in column A.
Make sure column B is empty and ready to accept the parsed names.
Select the names in column A
Goto the Data tab>Text to Columns
Select: Delimited>Next
Select: Comma
Click: Finish
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks