Using the Text to Columns Tool . One way to split data into multiple columns in Microsoft Excel is to use the built-in Text To Columns tool. This method is handy if you prefer to ...

Appending records from different data sets into a single list or data range can be tedious if you’re doing it manually. Instead, use Microsoft Excel’s VSTACK() function.