Data tips: break text across columns in Excel
In this self-help video, you will learn:
- how to break text from a single column into several columns, using Excel's built-in Text to Columns function;
- the importance of checking and cleaning your data when using this function.
This tutorial uses demonstration data from the fictitious project, The Letters of Bilbo Baggins: A Critical Digital Edition.
Methods shown here were tested in 2019 versions of Excel, on both Windows and Mac.
Links
