Split a Text by delimiter without a formula

Split a Text by delimiter without a formula
Last Updated on 12/05/2023
Reading time: 2 minutes

In Excel, there is a tool to split the text in your cell according to a delimiter without using a formula.

Data to Split

The text is split by delimiter without formula

In this document, we have addresses and we want to split them according to the comma.

Example with addresses

Split your text by delimiter with the tool Text to Column

This tool has always been present in Excel but few people know how it works.

  1. Select the column that contains the text to split
  2. Click on the menu Data > Text to Columns
Menu Text to Columns
  1. In step 1, choose the " Delimited " option and press Next
Select the delimited option in the dialog box
  1. In the next step, select the delimiter Comma to split your data and click on Finish
Select the delimiter to split your text

AND THAT'S ALL 👏👍😎

The text is split by delimiter without formula

Each time you have a comma in your original text, the text will be split on the delimiter comma, without formula.

3 separators mean 4 columns

Split text by delimiter with Excel function.

In 2022, Microsoft released a series of new Excel functions. One of them splits your text according to a delimiter. It's the TEXTSPLIT function.

TEXTSPLIT splits your text by delimiter

Leave a Reply

Your email address will not be published. Required fields are marked *

Split a Text by delimiter without a formula

Reading time: 2 minutes
Last Updated on 12/05/2023

In Excel, there is a tool to split the text in your cell according to a delimiter without using a formula.

Data to Split

The text is split by delimiter without formula

In this document, we have addresses and we want to split them according to the comma.

Example with addresses

Split your text by delimiter with the tool Text to Column

This tool has always been present in Excel but few people know how it works.

  1. Select the column that contains the text to split
  2. Click on the menu Data > Text to Columns
Menu Text to Columns
  1. In step 1, choose the " Delimited " option and press Next
Select the delimited option in the dialog box
  1. In the next step, select the delimiter Comma to split your data and click on Finish
Select the delimiter to split your text

AND THAT'S ALL 👏👍😎

The text is split by delimiter without formula

Each time you have a comma in your original text, the text will be split on the delimiter comma, without formula.

3 separators mean 4 columns

Split text by delimiter with Excel function.

In 2022, Microsoft released a series of new Excel functions. One of them splits your text according to a delimiter. It's the TEXTSPLIT function.

TEXTSPLIT splits your text by delimiter

Leave a Reply

Your email address will not be published. Required fields are marked *