Currently when I pull names from a program to excell I am getting a list of names that have the first and last name all in one cell in the format of (lastname,firstname). I need to split this into two columns. Is there a function that will find the comma and pull everything to the right or left of it? Thanks in advance.
Jason
Data > Text to Columns, Delimited, check Comma.
Select the column and go to Data|Text to Columns and select Delimited form 1st window.. click Next and select "comma" from Delimiters options...
Click Finish.
This will split the column into 2 columns...
Microsoft MVP - Excel
Where there is a will there are many ways. Pick One!
Please read the Forum Rules
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Preferred Charities: Lupus Canada and Sick Kids Foundation.
Feel Free to Donate if you want to, for the assistance you received today.
DUH, thanks guys. Someone at work asked me for a function for this and I don't use text to columns much so I didn't even think about it. Thank you for your help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks