Try this...

=SUBSTITUTE(A1,RIGHT(A1,2),$B$1) and pull down.

Where your list is in column A and the replacement number (or text) is in
B1.

HTH
Regards,
Howard

"VN01" wrote in message
...
How do I do a find and replace the 2 numbers at the end of the field in a
column?