The UK's Leading Professional Training & Business Solutions Provider

Email or CALL NOW on 01952 581550

Excel – splitting a column into two

We provide our delegates with ongoing inspiration and support via short ‘How to’ videos that you can watch and learn from. The latest tips are little things that speed up your work, making you super-efficient. You’ll be well on your way to becoming a productivity Ninja!

This week’s tip is about how to split one column into two. You may want to sort a spreadsheet by Last Name but only have a Full Name column of data. In order to split it you’ll need to insert a column to the right (Shortcut ALT + I, C) and then split the data so the surname goes over into your new empty column. Don’t forget to label up your new column heading! I’ll show you how in this short ‘How to’ video.


If you would like a copy of the file I used in this exercise and step by step directions, sign up for our Tips & Tricks blog.

Contact us on 01952 581550 for course dates and learn Excel with us!

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.