Tips for Excel, Word, PowerPoint and Other Applications

PROPER, LOWER, UPPER, and SUBSTITUTE

Why It Matters To You

Excel has many functions that can be used to transform and condition text. In our work, we often get data files from accounting systems or other systems where data isn't necessarily formatted in the way we need. We will talk about 4 functions that can help us out, PROPER, UPPER, LOWER, and SUBSTITUTE, in this Tip-of-the-Week.

How To ...

Here's a sample file with an extract of vendor names to show you how PROPER, UPPER, LOWER, and SUBSTITUTE can help you clean up a data file.

Notes

Last updated7/25/08
Application VersionExcel 2003
AuthorMichael Kan
Pre-requisitesNone
Related Tips None