Replacing a last digit to something else
Hi all,
I hope you can help me. I have a huge excel spreadsheet and all I want
to do is replace the last digit in each cell, no matter what it is,
number or letter, into an L or an M. One worksheet will be "L"'s and
one will be "M"'s. My biggest concern is just changing the last digit.
Any ideas? Thank you very much in advance! Jen
|