In this video we use IF, IFERROR, MATCH, INDEX, and Text functions to find a company’s abbreviation from a list of abbreviations and then highlight the abbreviation within a company’s name.
These are the before and after files needed to follow along to this video:
Excel With Wayne is an online Microsoft Excel Training Course taught by Dr. Wayne Winston. Dr. Winston is the world’s foremost Microsoft Excel Expert that teaches at some of the world’s largest organizations including Microsoft and government organizations such as the Navy and Army.
Please confirm you want to block this member.
You will no longer be able to:
Please note: This action will also remove this member from your connections and send a report to the site admin. Please allow a few minutes for this process to complete.
