View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
SS[_2_] SS[_2_] is offline
external usenet poster
 
Posts: 12
Default seperate contents of a cell to two cells

If i have the folowing in a column of cells,

column 1
000.000, 000.000
000.100, 000.001
000.200, 000.002

how can i split this into two columns of cells. to give

col3 col4
000.000 000.000
000.100 000.001
000.20 000.002


TIA.

SS.