Using Built-In Excel Functions Another way to split data into multiple columns is to use some of Microsoft Excel's functions.

Microsoft Excel is incredibly versatile, but there are a lot of functions you might not even know about. These are some of the best ones.

Microsoft Excel’s new text function TEXTSPLIT() is Excel’s TEXT TO COLUMNS feature in a formula and a bit more.

Learn to create efficient, interconnected Excel drop-down lists using range functions and data validation techniques. Multi-level drop-down ...