Excel – How to split a column in 2 or 3

Do you have a column containing a full name, like this:-

Before

….that you’d prefer to have separated into first and last name ?

It’s very simple to separate them using a few steps in Excel. Here’s how:-1. Select the column containing the name (by clicking on the letter at the top)

2. Click on the tab called “Data”

3. Click on the button called “Text to Columns” (as you can see in the screenshot below)

Text to columns

4. The following window will appear – just click “Next” to proceed:-

Deliminted

5. The following window will appear – in this case the Preview shows you have the correct option, so you can click on “Next”.

Delimiters

6. The following screen will appear – in this case the default option is fine, so you can click on “Finish”.

Step 3

7. Here’s the result:-

Result

 ~~~

If you enjoy this article, please click on “Like” to let me know – and/or write a comment below 🙂

Advertisements

Posted on March 28, 2015, in Learning Zone and tagged , , , , , , , . Bookmark the permalink. Leave a comment.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: