ExcelBanter - seperate contents of a cell to two cells

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - seperate contents of a cell to two cells (https://www.excelbanter.com/excel-programming/290327-seperate-contents-cell-two-cells.html)

SS[_2_]

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.

Arvi Laanemets

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.

All times are GMT +1. The time now is 10:39 PM.