How to split text in Excel by space | FIND, LEFT, MID, RIGHT, IFERROR formula | Excel Tutorial
In this video, I take a look at how to split text in Excel using formulas.
The main formulas we use for this are:
1. FIND - to find the position of a specified text within another text string
2. LEFT - to extract a given number of characters from the beginning of a text string
3. MID - to extract a given number of characters from the middle of a text string
4. RIGHT - to extract a given number of characters from the end of a text string
5. LEN - to calculate the number of characters (length) contained in a text string
TIMESTAMPS
0:00 - Introduction
PLAYLIST TO WATCH NEXT:
Pivot Tables Explained: https://www.youtube.com/watch?v=dK4q9...
I hope this has been of value to you. Please let me know in the comments below.
A big thank you to my subscribers – your support is much appreciated.
In case you have not yet subscribed, please SUBSCRIBE and click the BELL icon so you never miss out on new videos released on this channel.
MY PRIVATE EXCEL FACEBOOK GROUP:
/ excel. .
FOLLOW ME ON TWITTER:
/ akitamirike
#excel
#excelsplittext
#albertkitamirike