View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
bischofg bischofg is offline
external usenet poster
 
Posts: 1
Default Cut some of the data in a cell and move to the neext cell

I have data in a cell that contains Lat and Long data that is combined in one
cell with a comma between them. I need to seperate the data into two cells.
Example: -84.000001 39.000002. This needs to be 84.000001 in one cell and
39.000002 in another cell. I tried making a macro but with no luck.