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." ...

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.