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

Experts Exchange Adobe Expert (me)

Experts Exchange named me as the leading expert for Adobe Creative Suite. Check out my tutorial on the new artificial intelligence features in Photoshop.

Get in touch