seperate contents of a cell to two cells

  • Thread starter Thread starter SS
  • Start date Start date
S

SS

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.
 
Hi

From menu: Data.TextToColumns with delimiter set to Other=", "
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

papersources and papersizes really slow on some systems. 1
VBA set thick borders around non empty cells in range 0
counting blocks of data 4
List Box help please 2
How to accomplish? 3
merge two worksheets with different columns and data 7
VB code please 1
Sum orders in a month from a table 1

Back
Top