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
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
Site Admin
Posts: 32
Joined: Thu Jul 24, 2003 5:53 pm
Location: Alexandria, VA

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

Posts: 1
Joined: Wed Jul 28, 2021 12:09 am

Re: How do I separate text into separate columns in Excel?

Post by Evannnon » Wed Jul 28, 2021 12:10 am

It's easy to separate text into columns in Excel. This blog post will show you how! You can use the column function to insert a vertical line between two or more cells, which will break up your data into separate columns. To do this, highlight the cells that you want to be separated and then go to Data > Insert Columns (or press Ctrl+Shift+Enter). Then select the appropriate number of rows and click OK.

Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest