[QUOTE]

Hi Team,


From below data i want to extract only number to the adjacent cell.
Can you suggest a macro for this.

A B
ASDF4554 4554
ASD45548 ?
789SDFE54 ?
ASD89467 ?
WERWE4897 ?
JLKJ4545WER ?
7879FLDS ?
QWE897JVNL ?
LJKL789SDF ?



Thanks in advance !!

Regards,
Mallesh.