How do I separate text into separate columns in Excel?

Questions about running any kind of software, such as how-to's and fixes for MS Office, Adobe Acrobat, etc., or how to do stuff in Windows.
Post Reply
dlee
Posts: 2
Joined: Tue Feb 05, 2008 12:28 am

How do I separate text into separate columns in Excel?

Post by dlee » Sat Nov 08, 2008 3:31 pm

I have an excel spreadsheet that has first name and last name in one cell/column. I need to separate these into two columns - one for first name and one for last name. Is there an easy way to do this?
Last edited by dlee on Mon Nov 10, 2008 3:45 am, edited 1 time in total.

User avatar
hal_nesbitt
Site Admin
Posts: 32
Joined: Thu Jul 24, 2003 5:53 pm
Location: Alexandria, VA
Contact:

Post by hal_nesbitt » Mon Nov 10, 2008 3:42 am

Excel actually has a built in function for this, called "Text to Columns". If your first column contains data that you want to separate, such as last name, first name, just select the column > Data tab > Text to column > choose the separator (comma, space, tab, etc.) and then hit finish. Excel will then expand the column into separate columns with each piece of data, separated by the selected delimiter. One caveat to remember though, is to make sure that you have enough blank columns to the right of the selected column to hold the exanded data, otherwise the data in these columns will be overwritten.
"Maturity is stupid." - Benjamin Franklin

Post Reply

Who is online

Users browsing this forum: Ahrefs [Bot] and 2 guests