Have you tried EditReplace...? It should do what you want.

--
Regards,
Fred


"mulligbo" wrote in message
...
I have 3 different groups of letters. SMRC, SMIF and SMBD that I am importing
into excel. The spreadsheet that I am using that was built a long time ago
has me manually changing these to numbers. I would rather be able to make a
formula then copy and paste these into the right spot rather than doing each
one manually for over 2000 entries.

SMRC=303
SMIF=373
SMBD=383

If anyone can help that would be great.

Thanks

Bobby.