I've been pecking around for a while and have had no luck.
I have a column which is filled with text. The cells have between two and five characters. All cells end in either "A" or "R". I need to replace all of the last characters - all A's become N's, and all R's become A's. Problem being, A and R appear in the text in places other than the last character.
AA
SA
ABEAR
ATAA
MMFR
SHSR
OSSR
Does anyone have a quick macro solution for this? Thank you very much!
I have a column which is filled with text. The cells have between two and five characters. All cells end in either "A" or "R". I need to replace all of the last characters - all A's become N's, and all R's become A's. Problem being, A and R appear in the text in places other than the last character.
AA
SA
ABEAR
ATAA
MMFR
SHSR
OSSR
Does anyone have a quick macro solution for this? Thank you very much!