How to Split Text with Multiple Delimiters with Excel TEXTSPLIT #shorts

The new TEXTSPLIT function in Microsoft Excel allows you to split across columns or down by rows. In this video I'll show you how you can even use multiple delimiter to split text into multiple cells.

Requires Microsoft 365. The TEXTSPLIT function will not be available in Excel 2021 and earlier versions.

🚩Let’s connect on social:

👉 This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

#Excel

[samrathna]

This is cool. ❤
Please do a short video on Text join and that will be helpful for everyone.

[user_-vk]

thank you so much. please continue doing contents about excel. these are very helpful. again. thank you, thank you, thank you ❤️❤️❤️❤️

[damorgman]

Great video. I need to change my notifications so that every time you post a new video, a trumpet plays on my phone or something. So much better than the crazy nested formulas I used to use for this.

[Shantanu_Dam]

Madam, simply awesome as always. Great tutorial ❤

[marinagrey]

Cool and super helpful Leila as always 💪😎Thank you🙏🌸🥰

[abdurrobronik]

Really helpful 😊 thanks.
What formula we should use if we want this type of output “PowerPoint = Power; Point”.
Thanks in advance.

[Moni-ynkq]

Perfect timing, wss using text to column function just today.😅

[lizetgomez-lluguin]

what if am splitting by row and some delimiters are a "-" and some are alt+enter? I tried {char(10), "_"} and it appears that the {} expect only items in quotation marks

[sathishtechtrends]

But we can't find this farmula in 2021 edition. How to get latest farmula's in Excel?

[SpiceMonkey]

Is there a way to split the text but keep the delimiters as well?

[magiclovelinu]

I wish i knew this +1. I didn't even think how of googling it everyone made me thought i was alone.

[ankitagarwal]

When i create new Excel file on desktop by right click on new context menu .. how to set it to create a .xlsb file instead of .xlsx file??? Please help

[rwfrenchGenX]

Thank you for another cool video! I’ve been using Power Query for doing text splits because I work in AP and I get statements in PDF and sometimes the supplier has letters with invoice numbers for credit memos and as you know in Power Query you can very easily split by number to text as a preset. Is that possible with this feature?

[mauprism]

didnt work.... this function dosent exist?

[techbasengr]

Thanks for this.
I'm actually more interested in how you made the second item in the list show up in the next column