help with cells formatting

V

vikram

Hi

Do we have a way with which if I select column C, the cells in column
has two figures like cell C10 is 15,964.95 7,903.95
these two figures have a gap in between them

what i want is that a macro which runs in column c and if it finds suc
cells it inserts a column before column c and take 15964.95 in on
column and 7903.95 in one column

there are a lot of cells in column C like these
i would suy if it finds gap between two figures it takes them t
seperate columns

thank
 
A

Andy B

Hi

You can use Data / Text to columns. Delimited, with a space. This should do
what you want.
 
Top