Split text into different cells

How to Split text into different cells


Step: 1
Select the range of text to be separated.

Go to Data, Data Tools, Text to Columns. The Convert Text to Columns Wizard opens.

Step: 2

Select Delimited from step 1 of the wizard and click Next.

Step: 3

Select the Delimited option to separate text joined by delimiters, such as commas, spaces, or tabs.

Select one or more delimiters used by the grouped text and click Next.

Step: 4

Click the  button to the right of the Destination box to collapse the dialog box.

Step: 5

Click Finish.