LeanED Training and Consulting
[A Training and Consulting Company]

Say What?

A blog about learning, training, growing, and working from the universe of books, news, and academic research, and common sense.

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.


The LeanED Team