Question

How to copy cells from excel and paste as space separated text?

Answer 1

Steps

Copy all of your tab-delimited text. ...

Select the cell in Excel that you want to paste into. ...

Paste the data. ...

Select the entire column of data. ...

Open the Data tab and click "Text to Columns". ...

Select "Delimited" and click "Next". ...

Select the character that your data is separated by. ...

Choose the format of the first column.

Answer 2

use text to columns in data....