Announcing New Microsoft Excel TEXT Functions (TEXTSPLIT, TEXTBEFORE, TEXTAFTER)

Microsoft is releasing a handful of TEXT based functions that make splitting column values into multiple columns, super easy to do. For example, if you have a column of employee full names and need to split the names (first and last) into multiple columns, these new functions will do wonders.

In this video, you will get a demonstration of:
-- TEXTSPLIT()
-- TEXTBEFORE()
-- TEXTAFTER()

DOWNLOAD EXERCISE FILE USED IN VIDEO:

LEARN MORE EXCEL BY TAKING MY COMPLETE EXCEL COURSE:

[learnconceptually]

thank you sir, it really saves lot of coding. It's very simple sir🙂

[dawnbroadbent]

That is going to be awesome when it comes out!

[lucasrafael]

Thanks Mr Kyle! Your videos and your course are awesome!!!
I've tried to do this function in my computer, but I think that Excel isn't updated. I'll try later.

[linacastleofmystery]

You could split the column in power query too!
Love this, super exciting!!

[Theoriginalsaxocomedy]

Thanks as always Kyle sir.
Your videos are always easy to understand.
Textsplit is really helpful as well as the others too.

[samanthastoker]

Many thanks. Know just where I am going to use that!

[monikadhanotra]

HI SR....not having these functions textsplit, textbefore, textafter ? how to get these functions ?

[whodiditdesign]

The first thing we did with left/search worked fine but after that nothing would work. I work on a Mac but I have not had any problems until now.