Adding Ordinal Notation to Integers in Excel

This video demonstrates how to add ordinal notation to integers in Excel (e.g. changing 1, 2 and 3 to 1st, 2nd, and 3rd). A formula using the OR, IF, RIGHT, MOD, and CHOOSE functions places the correct ordinal notation (st, nd, rd, or th) after an integer.