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...
Watch video Announcing New Microsoft Excel TEXT Functions (TEXTSPLIT, TEXTBEFORE, TEXTAFTER) online without registration, duration hours minute second in high quality. This video was added by user OfficeNewb.com 13 May 2022, don't forget to share it with your friends and acquaintances, it has been viewed on our site 2,40 once and liked it 15 people.