About the Course
I spent many years learning the mathematical formulas in Excel but I never knew about the text editing formulas. Simple functions such as “LEN” which tells you how many characters there are in a cell have proven valuable over the years. When you’re dealing with data and you’re trying to control it for post-processing, text editing functions come in very handy. In addition, when you’re trying to clean up data, these functions make it a breeze.
For anyone that deals with large data sets, particularly with words and letters that need processing.
This course contains less than 10 videos making it easy to complete and has a total time just over 20 minutes.
You will need to be familiar with how formulas structured and linked in Excel. Therefore, this course will be ideal for beginner to intermediate level users.
- Text length function
- Data Trimming
- Font Selection
- Left and Right Trimming and Cropping
- Find and Replace
- Data Ordering
- Spell Check Function
- Text Editing Functions
- Len Function00:00:00
- TRIM Function00:00:00
- Consolas Font00:00:00
- Left/Right and Len Combination00:00:00
- Find and Replace00:00:00
- Ascending and Descending Order00:00:00
- Spell Check00:00:00