Fixed length ID Formulas - combined functions

FORMULATEXT to show formulas FORMULATEXT

Blank (isempty) VS “” (null string) Excel User tips

Lesson learned: Do not trust Google Sheets function Google Sheets

Validation based on another Validation COUNTA

Cuts string of list of items Formulas - combined functions

Extract current (Active) workbook name CELL

MATCH fumction, just a simple search Lookup and References