View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Arvi Laanemets Arvi Laanemets is offline
external usenet poster
 
Posts: 510
Default seperate contents of a cell to two cells

Hi

From menu: Data.TextToColumns with delimiter set to Other=", "


--
(When sending e-mail, use address )
Arvi Laanemets


"SS" wrote in message
...
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.