View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom[_2_] Peo Sjoblom[_2_] is offline
external usenet poster
 
Posts: 964
Default Cut some of the data in a cell and move to the neext cell

-84.000001 39.000002

You are right, I didn't even read that part, I just saw the above which is
space delimited but the OP obviously said comma, my bad.

--


Regards,


Peo Sjoblom

"Bob I" wrote in message
...
Think you mean "comma" not space.

Peo Sjoblom wrote:

Use datatext to column, select space as delimiter, make sure the next
column to the right is empty.
Record a macro while doing this