IntermediateText Functions
Skip blanks when joining an address
Join address parts into one line without leaving gaps where a field is empty.
TEXTJOIN
7 min25 points
Excel practice exercises
Real situations from working spreadsheets — sales targets, commission tiers, messy exports, aged invoices. Numbered in recommended order: start at 1 and work down, or filter to what you need.