Mike Song: The TQ Video Blog

Crazy Useful Excel Tip! (It’s Magic!)

How to Separate First Name and Last Name into separate columns

We often receive messy data. For example, a spreadsheet that contains cells with a person’s first and last name inside of one cell. When this happens, you can’t create a mailmerge because it would read, “Dear Harold Hamster” instead of “Dear Harold”.

Here is a crazy useful Excel tip that overcomes this challenge. Create headings for First Name and Last Name and then copy the first, first name into the first, first name cell under the corresponding heading. Do the same thing with the first last name. Then, place your mouse in the second cell under the name you entered and click Control + E. Like magic, Excel will take all the first names and place them in that column. Repeat for last name and you are done in a flash!

If you like this tip, please like, follow, and subscribe. interested in Get Control! of Excel team training? Contact us by completing the form or emailing me at info@getcontrol.net

Mike Song Outlook Tech Tips

How Can We Help?

Questions? Need a class? Interested in team training.

Complete the form for more info.

Mike Song

• Mike Song’s global mission is to save our world’s 2 billion information workers 15 days a year. • Mike is the award-winning author of the bestselling books – The Hamster Revolution for Email and Zip! Tips: The Fastest Way to Get More Done. He is the founder of GetControl.net, one of the world’s leading providers of leadership and time management training serving more than 20% of Fortune 500 companies. • Mike has helped millions via interviews with Good Morning America, CNN, NPR, Fox News, USA Today, and The Wall Street Journal. His bestselling books have been translated into 12 languages and are available in more than 50 countries. • Mike has even helped leaders from the Army, Marines, Air Force, Navy, and Secret Service to manage technology more effectively in order to keep our country safe. Now he’s here to help you get more done and have more fun at work. Please give a warm welcome to Mike Song! • Optional Fun Facts About Mike Song  Musician: Mike is an award-winning singer, guitarist, and songwriter whose band, All the Voices has warmed up for Bon Jovi, The Ramones, and 10,000 Maniacs.  Athlete: Mike is an All-American distance runner who frequently wins his age category in 5k road races.  Inventor: Mike currently holds a patent for a revolutionary new way to organize information. His idea is currently being used by 450 companies around the world.  Minority Owned Small Business