Tag: how to split data in excel

STEPS : Select the cell or column that contains the text you want to split.Click on Data TabClick  Text to Columns.In the Convert Text to Columns Wizard, select Delimitedclick Next. Select the Delimiters for your data. For example Comma, Space etc. You can see a preview of your data in the Data preview window. here we choose spaceClick  Next. Choose the Column data format or use what Excel choose for you. Here we choose General.Select the Destination, which is where you want the split data to appear on your worksheet.Click finish