Excel: How to split text into columns

If you need to extract data in Excel, you may want to use the Text to Columns tool. With only 3 steps, it's really easy to split text into columns.

In Microsoft Excel, the Convert Text to Columns Wizard takes text and splits it into columns. It is a handy tool to use with only 3 steps!

The Text to Columns tool can be used to split dates into Day, Month and Year columns or to extract data from your email lists – and much more.
Follow these steps:
– Select the data you want to split into columns.
Then go to Data and click on Text to Columns.
– In step 1 of the Convert Text to Columns Wizard tool,
Delimited” is selected by default; click Next.
– In step 2, select the delimiters and click Next. A handy feature is that you can see a preview of your data at the bottom.
– Finally, in step 3, select the destination where you want the cells to be displayed. Note that you could only select the 1st cell if you want. Depending on the number of cells created from your text, be sure to have enough space on the right of the 1st cell.

Text to Columns – Date

In this example, we want to split dates into 3 columns: Day, Month and Year.

The delimiter is / so we click on “Other” and add /. We can preview the selected data: 3 columns will be created as we wish.

We want the 1st cell to be in A2 so we enter A2 manually as destination or we could select it by clicking on the “select cell” window.

After clicking on Finish, this is the result. You might see a warning message if the cells you selected had already data in them.

Each argument is in a different column: day, month and year.

Text to Columns – Email address

Let say you gather a list of email addresses and want to extract all the data before the @ sign to create a customer list.

Once you have selected all your email addresses, clicked on Data, Text to Columns and Next on Step 1 of the Convert Text to Columns Wizard, you have to enter the delimiter @ next to “Other”.

After clicking next on Step 2, you will now select the cells where you want results to appear by manually entering them or by selecting them via the “select destination” window.

After clicking on Finish, you will see all the data before @ in column B and all the data after @ in column C.

Screenshot of Excel cells with email addresses data, split into 2 columns.

Now, you know how to convert text into columns in Excel!

If you wish to learn more about Excel Spreadsheets, join our certifying MS Excel Course!

Advertising
Analytics

Categories

AllAdvertisingFormatsPlatformsKPI'sAd News
What is Programmatic Advertising?

What is Programmatic Advertising?

Understand what programmatic advertising is and how it works to increase your ROI and become a programmatic specialist.

Read More
Programmatic Advertising: What is a DSP?

What are DSPs?

A DSP is a great tool to use but what does DSP stand for in marketing? What are some Demand-Side Platforms examples? Today, we answer your questions!

Read More

Best DSPs for Programmatic Advertising

Ted Jordan shares his list of best DSPs for Programmatic Advertising so you don’t have to lose time searching the internet to find the right Demand-Side Platform for your campaigns.

Read More
Programmatic Advertising: What is a SSP?

Supply-Side Platforms (SSPs) Explained

SSPs basics in advertising: learn what Supply-Side Platforms are used for and who use them. Get familiar with more programmatic advertising technical terms.

Read More

What is O&O Advertising?

Discover one more important jargon term used in Programmatic Advertising: O&O advertising. Get familiar with O&O formats and advantages.

Read More
Programmatic: Pixels in Advertising 101

Advertising pixels: types, pros and best practices

Learn the basics of Programmatic Advertising with Ted Jordan! Today, we explain what a pixel is in advertising with simple words and expertise. Ready to learn?

Read More

Categories

AllFunctionsToolsShortcut Keys

How to change shapes in Excel column charts

Learn how to easily change the columns shape in your Excel charts so your colleagues and customers will remember your impacting graphs.

Read More

How to use the LEFT, RIGHT and MID functions

Learn how to extract text in Excel with the LEFT, RIGHT and MID functions. Plenty of examples to learn from and functions are explained with simple words. If you start...

Read More

Excel IF statement: how to use it for 3 conditions

Learn how to use the Excel IF statement with multiple conditions and combine it with OR and/or AND functions!

Read More
Navigating with Tab, Enter, and Shift Key on Excel.

How to move between cells when arrow keys are not working (Excel)

Learn how to move between Excel cells without using your mouse or arrow keys. Discover more shortcuts and tricks below!

Read More

How to use the IFERROR function (Excel + Google Sheets)

Discover how to use IFERROR in Excel or in Google Sheets in 4 easy steps! No more errors on your documents or dashboards with IFERROR.

Read More
Cope Paste Options on excel with shortcut keys

Copy paste values like a pro! (Excel+Google Sheets)

Copy and paste values (not formulas) using shortcut keys in Excel or Google Sheets! Learn how spreadsheets professionals do it within seconds and become one of them. Save time now...

Read More