My Own Quick Excel Formula Lookups

This will become my own page of quick Excel formulas that I find myself looking up elsewhere far too often! It should flesh out over time.

Excel String Manipulation

Does any cell in a range contain a substring?
(Is the string contained in cell F4 a substring of any of the cells in column B)


Which row number in a range contains the partial match?


Return the contents of the column on the same row as the match.
(if the value A6 is found in the column A:A on AMAZON UPLOAD, then return the corresponding value in column O)


Excel Date Manipulation

Convert the date name into the date number