~ HOW TO VIDEO INCLUDED! ~
I am often asked about how to split 1 column into 2, for example you may have full names in a column and want to split them into first and last so you can sort them by last name. It will be useful in many other situations, instead of using TEXT formulas. You may want to join columns such as address fields. You can also use Flash Fill to extract names from a list of emails.
Here’s my new tip for you – have you seen Flash Fill in Excel? In the old days, we had to split a column of text into multiple columns by using Data, Text to Columns. It worked, but it was a bit clunky. Flash does it instantly. The short cut keys are Ctrl + Enter, Ctrl + E – if you’d like to watch my 2 minute ‘How To’ video you can see how it’s done.
If you’ve already got a copy of my Excel Cheat Sheet are you using those shortcuts every day to save time?
If you’ve slipped out of the habit, didn’t get one or have lost it, give us a call on 
01952 581550 and we’ll email you another copy.
If this is useful to you, you can sign up to receive more free tips directly to your inbox!
You will also receive our Excel Cheat Sheet to get you started.
