Skip to content

Lessons in your language are coming soon. Formulas already work in your Excel language.

06

INDEX and MATCH

4 lessons · 12 exercises

Start
    1. 1. LEN: count characters (0 of 3 done)
    2. 2. LEFT and RIGHT (0 of 3 done)
    3. 3. MID: text from the middle (0 of 3 done)
    4. 4. FIND and SEARCH (0 of 4 done)
    5. 5. Split names and emails (0 of 4 done)
    6. 6. Wildcards: * and ? (0 of 4 done)
    Module page
    1. 1. Join text with & and CONCAT (0 of 3 done)
    2. 2. TEXTJOIN: join with a separator (0 of 3 done)
    3. 3. UPPER, LOWER, PROPER (0 of 3 done)
    4. 4. TRIM: remove extra spaces (0 of 3 done)
    5. 5. SUBSTITUTE: replace text (0 of 3 done)
    6. 6. TEXTBEFORE and TEXTAFTER (0 of 4 done)
    Module page

Functions in this module