Text Functions
Spreadsheets clean and reshape text too. LEN counts characters. LEFT(text, n), RIGHT(text, n) and MID(text, start, n) cut pieces out. UPPER, LOWER and PROPER change case. TRIM removes extra spaces. SUBSTITUTE(text, old, new) replaces text.
In this course each line of an example is one cell: the address, a colon, then what is in the cell. A line starting with = is a formula. Press Run to see the sheet with every formula worked out.
Exampleexcel
Quick check
What does `=LEFT("Accra",3)` give?
Your turn: write the code
Show the year part (4 characters starting at position 4) of the code in A1 inside B1.
Finish the quick check (and any code exercise) to complete this lesson, or mark it done yourself.
Tip: use the left and right arrow keys to move between lessons.