Listed below is just one of many stores that are listed in my spreadsheet.
Column A1 | Column B1
---------- | ---------
Mays Dept Store 551 | Mays Dept Store
How do I have excel find all the cells with the info from column A1 and replace it with the proper data of column B1.