copying numbers and leaving the text

**melvin** · 01-07-2005, 09:45 AM

Hi people,

I have a column that has both text and numbers in it. Eg:

Blue
Blue
2
Yellow
1
Red
Red
Red
3

I would like to be able to copy only the numbers into a new column, so that the text isn't copied over. I would like the spaces (i.e. rows) between the numbers to remain as they are.

Can this be done?

Sincere thanks,

**Zer0-G** · 01-07-2005, 10:01 AM

hi,

you should be able to filter it based on the TYPE property.

=IF(TYPE(A1)=1,A1,"")

will show any numbers and blank for anything else i think.

Cheers.
Gareth