Microsoft hasn’t yet released the Textsplit function out of beta testing in the 365 edition of Excel. So until you have that function available but you want to use a function to split text on the fly, you can momentarily convert the text into XML and use the FILTERXML function to do the splitting.
About Bob:
Bob Flisser has been a software trainer since the mid-1990s, specializing in the Microsoft and Adobe suites. He has written and recorded video courses for LinkedIn Learning, Pluralsight, Skillsoft, Tuts+, and others, and is the co-author of a dozen books of tips and shortcuts for Microsoft applications. He has also written magazine articles and training manuals and set up corporate training centers.
Connect with Bob:
Experts Exchange: www.experts-exchange.com/memb...
LinkedIn: / bobflisser
Learn more about Experts Exchange:
Info: go.experts-exchange.com/
Try free for 7 days: go.experts-exchange.com/pricing
#excelforbeginners #excelhacks #exceltutorials