_edited.jpg)
A brand new function, only available on Microsoft Office 365, to help you split your text before a specific delimiter. Think Text to Columns but easier!
The video shows the TEXTBEFORE function in use.
The first written calculation is below:
=TEXTBEFORE(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 the first occurrence of this delimiter and display any data that appears before it. That's why we get the first name.
The second written calculation is:
=TEXTBEFORE(B3," ",2)
We now want to split out the first and the last name, so adding the 2 at the end of the calculation tells Excel to look for the second occurrence of the delimiter. As a result, the calculation result will be the first and the last name.
Comments