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

Save hours splitting first and last names apart

Never ‘Dear Mrs Customer’ again

How can your customers be impressed if you address communications with ‘Dear client’, no greeting or without their name in full?

Solve the problem of splitting first and last names apart with the fabulous but poorly known function in Excel called ‘text to columns’. Found in the data menu, it will split information based on the criteria you specify such as space, comma, colon and so on.

Is your customer information not in Excel? It’s easy to import it from another program. Save the original as a text or CSV file and import into Excel. Within Microsoft a simple copy and paste works perfectly.


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