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

ChatGPT now has a desktop app

In addition to using ChatGPT in a web browser, you can now download it as an app on your desktop. There are editions for Windows,

Get in touch