This video shows Dr. Evan Matthews explaining how to replace words in an Excel document with another word. This is useful when trying to get uniformity to your categorical data for whatever reason.

Excel Skills Playlist
https://www.youtube.com/playlist?list=PLf85BhZ0yM_siy9l4nDMG1kOveyTcWYBs

Link to Dr. Evan Matthews website.
https://sites.google.com/site/evanmatthewseportfolio/home

Please take the opportunity to connect and share this video with your friends and family if you find it useful.