How about inserting a column between D and E first. This way, the existing
data will not be written over when you do text to columns. If you think the
data in column might split to more than two columns, insert more columns in
between first.

-Simon


"wnfisba" wrote:

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!