If I have long list of three digit numbers in an Excel column that have the
number 8 in them how can I replace the 8 in the last digit (eg 458) without
changing the second digit when there is an 8 within it (eg 488). I've tried
"text to columns" & then concatenating but this disrupts the formular.
Thanks for any help you can provide.