I need to change certain abbreviations to full words. not all cells contain abbreviations. I have in column A the abbrev and in column B i have the full word counterpart, and in column I i have the list of data to look through. I can move the columns around if neccessary.
Examples:
MTG
BK
ASSN
to
Mortgage
Bank
Association
Thank You in advance
Bookmarks