How To Split Text in Microsoft Excel

There’s nothing worse and no bigger headache than when you receive an excel spreadsheet full of contact information and find that contact names are entered in one column. It makes mail merges an absolute NIGHTMARE!

In this PA Pages tutorial video, we show you how to use a simple formula to split text into separate columns so that you can clean it up and ensure names are always right.

PA Pages

PA Pages is all about YOU! We know that the role of the Personal Assistant or Executive Assistant along with other various Office Professional roles within the Australian workforce has changed substantially over recent times. Today many of these roles hold a large amount of influence, decision-making and require us to be a Jill (or Jack) of all trades. Our mission is to provide you with the ultimate online resource where Office Professionals like you can be inspired and empowered to be the best leaders, problems solvers and support person in the office. We aim to provide you with everything you need through our online community whether you have a question about the workplace or your career, need to organise a team building activity, send a gift, book a chauffeur driven car, or want to know how to do something you will find it all here on PA Pages. Personal Assistants, Executive PA, Virtual Assistants, Secretaries, Receptionists and more!

0 Comments

No Comments Yet!

You can be first to comment this post!