Home · Course Details

Learn to use Excel Text Functions to clean up imported text and manipulate how textual data is stored and displayed.

  • Duration: 90 minutes
  • Category: Excel
  • Platform: Adobe Connect
  • Level: Experienced
  • Pre-requisites: Basic familiarity with Excel formulas
  • Version: Suitable for 2010, 2013, 2016 and Office 365

  • Understanding when to use Text Functions
  • Use Text Functions to manipulate text based Excel data
  • Use Text Functions to ‘clean up’ imported text

Topics covered include:
  • Using PROPER
  • Using UPPER
  • Using LOWER
  • Using CONCATENATE
  • Using LEFT
  • Using RIGHT
  • Using MID
  • Using LEN
  • Using SUBSTITUTE
  • Using TEXT
  • Using VALUE

No pre/post work required

Name Date Time Location Cost

Not quite the content you’re looking for?

Need a course you can’t find content for on our website? We have quite possibly the largest catalogue of course content in Australia! Let us know what you’re looking for and we will customise something for you.