Category: SEARCH

Middle name + 1st name

Cuts string of list of items

Always get 1st name (or last)

Worksheet name, dynamically using formula

Text-to-Columns, dynamically using formulas

Extract current (Active) workbook name

Get column name (columnname as A,B,C, etc) as input inside cell

Extract Address into table

MID + SEARCH to convert cell to rows