Text Function - TEXTSPLIT
- Rachel | The Blue Star Academy
- Sep 26, 2022
- 1 min read
A brand new function, only available on Microsoft Office 365, to help you split your text by a specific delimiter. Think Text to Columns but easier!
The video shows the TEXTSPLIT function in use.
The written calculation is below:
=TEXTSPLIT(B3," ")
Cell B3 contains the data you want to split and " " (a space character) is the delimiter you want to split by. The function will look for occurrences of this delimiter and split your data by each one. In our example, our data is split into first name, last name and age, all appearing in separate cells.
Comments