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()
https://techcommunity.microsoft.com/t...
DOWNLOAD EXERCISE FILE USED IN VIDEO:
https://www.officenewb.com/post/annou...
LEARN MORE EXCEL BY TAKING MY COMPLETE EXCEL COURSE:
https://www.udemy.com/course/microsof...