Debbie Mayo-Smith international inspirational motivational how-to speaker technology, time management, improving business performance
Motivational Speakers, Sales, Marketing, Time Management, Productivity, Technology, Tips

How to save hours working on databases

Your P.A has just spent five hours typing up a new database. Uh, oh. One field has the first and the last names in it. But you wanted to do a mail or email merge with the first names only!

While 99 out of 100 people will fritter away countless hours manually retyping in the information or manually fixing it, here's a great tip when you face this dilemma or one similar (when you want to separate data within a column)..

The answer lies in Excel and it’s a simple three step Wizard, and it's called Text to Columns. 

  • Select your Data drop down menu.
  • Select Text to Columns data>text to columns
  • Highlight the column that you want (and make sure you have a lot of empty columns to the right of it so you don't write over information already there).
  • Delimited will appear selected.
  • Hit Next.
  • Select space (this will mean every time there is a blank space, the information will be put in a new column).
  • Hit Next, then hit finish!

Voila. Literally hours of work saved by the push of a button.

Debbie Mayo-Smith (BSc Hons Econ) is an International Motivational Business Speaker and Managing Director of SuccessIS! ( and a leading specialist in easy practical ways to improve business profitability, personal productivity and Internet marketing. Debbie lives in NZ and travels the world speaking, writing and training. By the way, if you'd like to get lots of neat tricks like this, plus marketing and business development tips, 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


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!"