Many people believe that Excel's Power Query Editor is too complex for them—however, it was designed specifically to be user-friendly and is a great way to split data into multiple columns.

1. In Excel, select the cell, group of cells, or entire column that has the text you want to split. It'll need to contain two pieces of data separated by a "delimiter." ...