Split text in an Excel column to multiple columns #TIL

We’ve all been there, right? You’re given an Excel file which you need to import somewhere. The tool wants the name and last name in separate columns. Yet here you are, staring at thousands of entries in Column A, containing both. How do you solve that? As it turns out, it’s relatively simple.

If you want to spllit values like “Timmy Tester” into separate columns, you can use the “Text to Columns feature in Excel to do some magic.

You can find the full explanation on this page. Simple once you know how, right?

Happy spreadsheet editing!

Discover more from PowerUser Guide

Subscribe now to keep reading and get access to the full archive.

Continue reading