Microsoft Excel - Split to multiple columns by Capital Letter eg, Resolved Apology provided

Asked By Shelley Watt on 12-Mar-18 11:02 PM

I currently have a data set that is updated monthly .

I use Power Query to pull the data so I don't have to make changes each time it updates.

I would like to split one column into multiple columns by Capital Letters.

eg Currently it looks like (below) all in one column:

Resolved Apology provided, Concern registered, Explanation provided

I would like to split it so the data is in 4 columns

Resolved         Apology provided       Concern registered       Explanation provided


I would like to be able to put it through power query so again when new data comes in, it automatically occurs.

Any help would be awesome.