Hi
Select the column/range and try Data|Text To Columns. Tell the wizard that
the text is delimted and select Space as the delimiter.
Save a copy of your data before you start!
--
Andy.
"Ciara" wrote in message
...
Hello,
I have pasted values from notepad into excel. I can't however get the
values
to go into seperate cells. for example cell A1 has 7 numbers seperated by
spaces, the same for A2 and A3 etc.
2460070 -181.000000 4921.000000 587.723022 -1.758458
-1.446573 0.000000
Is there a way to get the numbers into seperate cells?
Thanks
|