Motivational Speakers, Sales, Marketing, Time Management, Productivity, Technology, Tips

Database consistency. How not to look foolish

Do you have database information in mixed upper and lower case? This could happen from different people entering information over time or your database accumulates from website data entry. If you use this data in correspondence you'll look foolish if you write Dear JOHN. Consistency should rule - right?

Your Quick Fix
It doesn't matter if it's 1 or 10,000 names. Your quick fix is the Proper function in Excel. You'll find it in the functions menu (fx). It's a veritable gem, changing the first letter of each word to upper case, the rest to lower case.

So {NAMEL} becomes {NAMEP} or {NAMEU} becomes {NAMEP} (bet you're wondering how I did that huh?)

To use it simply enter a new empty column next to the one you want to turn proper. Click fx; select proper. Then all you do is put your mouse in the very first cell of the column you want changed. Hit okay and then drag the right hand corner of the cell down to the very last piece of data. Voila! The whole column is proper. Don't forget to highlight your new column, copy. Then paste "paste special" right over it to turn it from a 'formula' to actual text.


Debbie Mayo-Smith called the Queen of Productivity is an International Motivational Business Speaker and best selling author! (http://www.successis.co.nz) Let Debbie help you with easy practical ways to improve your business profitability, personal productivity and work life balance. Debbie lives in NZ and travels the world speaking, writing and training. Why not enrol for our free newsletter?


This article is copyright to Debbie Mayo-Smith & SuccessIS. You may use it for your newsletter, website or as an article. It can be reproduced - but in its entirety and with inclusion of Debbie Mayo-Smith as the author and the weblink www.successis.co.nz


Share/Bookmark

Free Quick Tips Newsletter
You'll love this succinct monthly tip newsletter focused on improving your business results and productivity.

View and sign up now!!!

Andrew Gardner; Investors Edge

"Get on her email list mate! She sends brilliant tips every month. It’s the one newsletter I love to get!"