FormulaGym
XP 0
Streak 0

Excel functions for cleaning up data

Exports from other systems are rarely tidy. These functions help you check what is missing, pull codes apart and make lookups fail gracefully.

Typical jobs

  • Check how many entries are really numbers
  • Split a prefix off an ID or code
  • Spot duplicates and missing values
  • Show a clear message when a lookup finds nothing

6 functions to learn

Other jobs