Clean Data is Profitable Data
Register now for a 30-minute Skill Builder Workshop on Data Cleanup! www.leaned-train.com/datacleanup
It's not unusual to buy a mailing list that is in all caps. That's fine for address labels, but doesn't look professional in a personalized letter or note to a potential customer. You can get the data in shape using a combination of CONCATENATE(), MID(), UPPER(), LOWER(), and PROPER(). For example, change "SMITH" to "Smith" with this simple formula (where A1 is the cell reference for "SMITH"):
You should register now for one of the weekly online Data Cleanup Workshops. They are small, quick, interactive sessions where you learn by doing.
STOP SEARCHING, START KNOWING
The LeanED Team