Thread: break up text
View Single Post
  #1   Report Post  
Ciara
 
Posts: n/a
Default break up text

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