TEXT – Excel Function
What it does: The TEXT() function takes a text input and formats the text according to format you select. Plain English: Many
SUBSTITUTE – Excel Function
What it Does: The SUBSTITUTE() function in Excel substitutes one or more instances of a string (or number) for something
SEARCH – Excel Function
What it Does: The SEARCH() function in excel locates the position of a string inside of a cell. When searching for text
MATCH – Excel Function
What it Does – Locate the position (often the row number) of an item in an array. Arguments: MATCH(lookup_value,
FIND – Excel Function
What it Does: The FIND() function in excel locates the position of a string inside of a cell. When searching for text