How to Split Cells to Rows and Columns with TEXTSPLIT in Excel #shorts

Sometimes you might receive data with data all in the same cell. With Microsoft's new TEXTSPLIT function in Excel you can now split cells in rows and columns. This way you can create proper data table for further data analysis.

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

[Excelambda]

Cool!! Important fact: Every TEXT...functions returns text. ("numbers" are left aligned)
To turn eventually numbers into numbers format we can use:
=LET(t, TEXTSPLIT(A2, "=", ", "), IFERROR(--t, t))

[ScottMattes]

That is so helpful, to people whose company has whatever version of excel that supports the function <deleted grumbling> - please consider putting the minimum version required for the feature prominently on the video

[JOBMILI]

I am a teacher. I watch your excel tutorials and then teach my students

[nairobi]

Never had a specific need, but good to know. Thumbs up ...

[marinagrey]

Super helpful as always! Thank you Leila ❤

[gabrielevallerga]

Leila, I am following you since a while and i appreciate your work. Thanks a lot

[PovilasPanavas]

i needed this quite a few times, and didn't this existed. Thank you!

[saibharatDSB]

This is what I was looking for, a month back

[Kdevana]

Why my excel 2021 has no text split, what's your version, and also data from picture not available pls tell me what's your version

[abhinaviyer]

You are the best, i took your course in udemy

[dudezon]

What if I have to do vice versa...I mean cells to text

[shamaym]

Hi Leila I have the Escel 365 - but the function is not in. How should i get it ? thanks so much for all you teach us !!!

[hillsgaming]

Hi Ma’am, could u please tell me what if i have to inverse it, is there any formula we can use.

[Mikenetcom]

what can I do if it is not =TEXTSPLIT in my EXCEL 2016? I see only =TEXT. Also I have not =WRAPROWS

[hansklein]

Col and row delimiter in one, thanks for sharing! 🫡😊

[kingwesleyXIV]

What if you want the names as a row. The numbers as a row but below the names 🤔

[dolittlediehard]

❤ but it doesn't work with office 2019 or earlier.

[suryawardana]

why textplit formula missing on my excel app but not on my excel web., did anyone know? (im curently using microsoft home and student version)

[vinodpatil]

If = and, not in text then how to split

[RacketTattoo]

But whays the point? It would be easier and faster to manually type the info into different columns than type it all in one cell and then use the textsplitter