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

msexcel_tip_11_C.jpg

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"):

PROPER(A1) 

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