Essentials · Formulas

Text and Dates

4 lessons and 56 marked steps, with a workbook to open in Excel alongside. Your first two lessons on LogicExcel are free with a free account; after that every lesson opens with the All-Access Pass.

1. 1. TEXTBEFORE, TEXTAFTER and TEXTSPLITAll-Access Pass

   Split variable guide and tour text with the modern delimiter functions, ignore accidental empty parts, and feed a retrieved booking value into the same parsing pattern.

   14 marked steps

2. 2. LEFT, RIGHT, MID and LENAll-Access Pass

   Extract fixed parts of a controlled booking reference, use LEN as a structural check, and maintain an inherited delimiter formula without treating fixed positions as universally safe.

   14 marked steps

3. 3. Finding, cleaning and joining textAll-Access Pass

   Locate text with case-aware and wildcard searches, replace selected text deliberately, and assemble a dynamic booking handoff without hiding source problems.

   14 marked steps

4. 4. Date parts, EOMONTH and date mathsAll-Access Pass

   Work with real Excel dates, extract calendar parts, calculate month boundaries and produce an operations label whose arithmetic remains auditable.

   14 marked steps

Finished Formulas? Sit the Formulas exam for its certificate.