"rine9558" wrote in message
...

I have a block of cells that contain a number,a character, or nothing. I
would like to select the cells and organize the numbers into columns,
ignoring the characters. Not all of the rows contain all the numbers so
when a row doesn't have a number the cell in that column should be
blank.
The numbers change each time. Is there a "straighten data" macro out
there somewhere?
Thanks,
Chuck


A block? Is your data in a single column, or a number of rows and columns?
Do you want the numbers to end up in a single column or in the same columns
they started out in? Would it be satisfactory just to clear the non-numeric
cells?

--
Bob Kilmer