I would probably build a lookup table and use a lookup function. One column (lookup column) contains all of the different variations, and the second column contains the standard you want to return. VLOOKUP() is probably the most common starting place to learn about lookup functions: https://support.office.com/en-us/art...8-93a18ad188a1