Thread
:
seperate contents of a cell to two cells
View Single Post
#
2
Posted to microsoft.public.excel.programming
Arvi Laanemets
external usenet poster
Posts: 510
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.
Reply With Quote
Arvi Laanemets
View Public Profile
Find all posts by Arvi Laanemets