Hi, I am a newbie here. I have two columns with the contents shown below:
Screen Shot 2021-11-21 at 12.39.15 AM.png
Now I want to replace the word "bb" in Column B with "cc", if "aa" is found in Column A in the same row. The desired result is shown below:
Screen Shot 2021-11-21 at 12.39.30 AM.png
Can this be done with the Excel formulas? Thank you.
Bookmarks