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

Get in touch