Administration and Executive AssistantTier 250 minintermediate

Text Cleaning: TRIM, SUBSTITUTE, FIND

Fix messy text data from imports and manual entry.

What you will learn

• Use TRIM to remove extra spaces
• Use SUBSTITUTE to replace characters
• Use FIND and SEARCH with REPLACE
• Understand case-sensitivity in text functions
• Chain multiple functions for complex cleaning

Excel skills

TRIM, SUBSTITUTE, FIND, SEARCH, REPLACE, UPPER, LOWER, PROPER · Text Manipulation

The task

Three hundred contacts came across from the old CRM and the formatting is a mess. The Raw tab is what we got. The Cleaned tab is where I want the tidy version.

You work in a real spreadsheet in your browser, and your answer is checked against hidden traps the moment you submit.

Try this lesson free