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

did you know that excel's textbook function Works across rows as well as columns in this case we have our data written like this in a single cell and we want to bring it into multiple cells that looks like this no problem for text split let's start with text split our text is this now we can make use of the column delimiter and the row delimiter so what do we want the separator of the columns to be it should be the equal sign so let's put that for our column delimiter next is the row delimiter that should be the comma I'm going to go with comma space and close the bracket press enter and I get everything spilled properly that's it for today don't forget to subscribe for more tips

Channel: Leila Gharani

Views: 123,401

Keywords: XelplusVis, Leila Gharani, Advanced Excel tricks, Excel online course, Excel tips and tricks, Excel for analysts, Microsoft Excel tutorials, Microsoft Excel, Excel 2016, Excel 2013, Excel 2019, XelPlus, Microsoft 365, Excel 365, excel split text, split text rows and columns, excel split cells

Id: k-9Dks8FTjo

Length: 0min 51sec (51 seconds)

Published: Sun Jul 23 2023