Split Columns with Text to Columns

Please sign up for the course before starting the lesson.

The Text to Columns tool is well known and used regularly to split columns in Excel. Here we can see how to use it, as well as some tips and tricks associated with it e.g. use a delimiter (e.g. the implied columns are split with a comma, or dash), use a fixed width (e.g. the first 5 characters are columns A, the next 10 are columns B etc), importing credit card, bank account and other numbers that are either very long or start with a zero exactly as they are without dropping the zero or rounding the numbers at the end.

Back to: Data cleanup in Excel > Split columns in Excel