Microsoft Excel: Text Functions

Wishlist Share

About Course

Clean up and reshape text in Excel with functions such as TRIM, LEFT, RIGHT, MID, LEN, FIND, SUBSTITUTE, PROPER, TEXT and TEXTJOIN — ideal for tidying imported lists of names, codes and addresses.

This course is an independent introduction for learning purposes. Product menus and features change over time, so check the current official documentation.

What Will You Learn?

  • Remove extra spaces and fix capitalisation Extract parts of text with LEFT, RIGHT and MID Join text with & and TEXTJOIN Format numbers and dates as text with TEXT

Course Content

Course Lessons

  • Cleaning Text
  • Extracting Text
  • Joining & Formatting Text

Sources & Further Reading
The official guidance this course is based on.

Final Assessment

Student Ratings & Reviews

No Review Yet
No Review Yet

Want to receive push notifications for all major on-site activities?

✕