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
     
Back to: Advanced Excel Course > Text Functions