I have a spreadsheet and I want to split a column in two at a certain point.
I tried entering "Rule ID%Message" and then using Data==Text to Columns
delimiting by "%". The problem is that it split-off the word "Message" and
moved it over from Cell D to Cell E. At this point in the spreadsheet, I
would like to instead split cell D in two. Is this possible??? Cell E has
other data in it as does Cell C and Cell F.

So Row 46 in the spreadsheet has...FUNDING 20 Report
I would like Row 47 to have two sections...Rule ID | Message

Any help would be GREATLY appreciated.

Thanks!