Take text in one or more cells and split it into multiple cells using the Convert Text to Columns Wizard.
Process -
- Select the cell or column that contains the text you want to split.
- Select Data > Text to Columns.
- In the Convert Text to Columns Wizard, select Delimited > Next.
- Select the Delimiters for your data. For example, Comma and Space. You can see a preview of your data in the Data preview window.
- Select Next.
- Select the Destination in your worksheet which is where you want the split data to appear.
- Select Finish.
CAclubindia
