Text Functions- covered in Intermediate course
Below a listing of what you would have learnt in the Intermediate course which feeds into this Advanced course.
Please check that you are comfortable with these items.
- Fitting text inside a cell
- Quick entry of rows of data
- Quick Drop Down List
- Printing Tips
- Get Excel to read out the text and numbers
- Join text from many cells
- Extract parts of the text from cells
- Force Excel to see the value (instead of text)
- Change text to lower, UPPER or Proper case
- Remove unnecessary spaces