Find & replace
 

How do I do a find and replace the 2 numbers at the end of the field in a
column?

Find & replace
 

Assumptions: Data is in column A, replacing "12" with "34"
=IF(ISNUMBER(FIND("12",A2)),REPLACE(A2,LEN(A2)-1,2,"34"),A2)

Copy down as needed. Then, if you want, copy and paste special-values only
to get static values.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"VN01" wrote:

How do I do a find and replace the 2 numbers at the end of the field in a
column?

Find & replace
 

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?