V VN01 Apr 8, 2009 #1 How do I do a find and replace the 2 numbers at the end of the field in a column?
L Luke M Apr 8, 2009 #2 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.
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.
L L. Howard Kittle Apr 9, 2009 #3 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
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
