Between the Sheets — Excel podcast episode 20: Split text in Excel using the FILTERXML function.

In partnership with Experts Exchange.

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.

Share:

Facebook
Twitter
Pinterest
LinkedIn
On Key

Related Posts

Excel 365 for Busy People

Are you short on time and need to learn or brush up on intermediate and advanced Excel? Check out my course, “Excel 365 for Busy

Get in touch