Question

Explain separate text with.​

Answer 1

Explanation:

words can be expressed

Answer 2

Answer:

select the cell or column that contains the text I want to split.

select data>Text to columns.

In the convert Text to columns wizard,select Delimited> Next.

select the Delimiters for Ur data.For example,Comma and Space.You can see a preview of your data in the Data preview window.

select Next.

select the column Data Format or use what Excel choose for u.

select the Destination,which is where u want the split data to appear on your worksheet.

select Finish.