Advanced Excel tricks #1 - Text to columns

Описание: Series on Advanced Excel for Auditors
Trick No. 1 - Text to columns

Steps -
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, commas and Space. You can see a preview of your data in the Data preview window.

Select Next.

Select the Destination in your worksheet where you want the split data to appear.

Select Finish.