In Excel, there is a tool to split the text in your cell according to a delimiter without using a formula.
Data to Split
In this document, we have addresses and we want to split them according to the comma.
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.
- Select the column that contains the text to split
- Click on the menu Data > Text to Columns
- In step 1, choose the " Delimited " option and press Next
- In the next step, select the delimiter Comma to split your data and click on Finish
AND THAT'S ALL 👏👍😎
Each time you have a comma in your original text, the text will be split on the delimiter comma, without formula.
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.