Macro code to find and delete numbers

Is there a macro code that can find and delete numbers that are aligned at the right hand side.

for instance:

E1: The
E2: Man
E3: 3
E4: Ran

I need to find the number and delete the cell. Also the other cells should then shift up. Is this possible?

Hello Dtd509,

You show a number in your post left aligned. Are the numbers that right aligned numbers, text, or both? I ask this because you don't mention if the data is imported from another source.

Thanks,
Leith Ross

The numbers are on the right hand side of the cell, but they are actually not right aligned by definition. I only want to delete the cells that contains numbers only.

Please Login or Register  to view this content.

regards

Dav

It is not deleting them they still remain in row E any thoughts why?

How about something like this?

Please Login or Register  to view this content.