How to Split Cells to Rows and Columns with TEXTSPLIT in Excel
Vložit
- čas přidán 22. 07. 2023
- Join 300,000+ professionals in our courses: www.xelplus.com/courses/
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.
🌍 My Online Excel Courses ► www.xelplus.com/courses/
🎬 LINK to more CZcams Shorts videos: • Shorts (Tips, Tricks &...
👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com/
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: www.xelplus.com/course-quiz/
🎥 RESOURCES I recommend: www.xelplus.com/resources/
More resources on my Amazon page: www.amazon.com/shop/leilagharani
🚩Let’s connect on social:
Instagram: / lgharani
Twitter: / leilagharani
LinkedIn: / leilagharani
👉 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
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))
Amazing！Thanks for sharing!
I am a teacher. I watch your excel tutorials and then teach my students
That is so helpful, to people whose company has whatever version of excel that supports the function - please consider putting the minimum version required for the feature prominently on the video
Never had a specific need, but good to know. Thumbs up ...
Leila, I am following you since a while and i appreciate your work. Thanks a lot
Super helpful as always! Thank you Leila ❤
Awesome, thanks for the tip dear 💯🎉
i needed this quite a few times, and didn't this existed. Thank you!
This is what I was looking for, a month back
Well done
You are the best, i took your course in udemy
always amazing
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
What if I have to do vice versa...I mean cells to text
Nice.
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 !!!
Hi Ma’am , could u please tell me what if i have to inverse it, is there any formula we can use.
what can I do if it is not =TEXTSPLIT in my EXCEL 2016? I see only =TEXT. Also I have not =WRAPROWS
What if you want the names as a row. The numbers as a row but below the names 🤔
❤ but it doesn't work with office 2019 or earlier.
Col and row delimiter in one, thanks for sharing! 🫡😊
Thanks for watching!
To col function excel how
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)
most likely you have the 2016 version (I have the same problem on my work computer, so I am using my personal one to solve those problems)
If = and , not in text then how to split
Some sorta delimiters gotta be there right?
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
When you import data it looks like this sometimes.