Text to Columns

sariyaj

Is there a way to use a certain word as a delimiter and keep that word. 

For example, if I am trying to separate a column using the word "city", can I do that and keep the actual word in the previous column.

Example:

from this:

Oklahoma City OK 12345

to this: 

Oklahoma City

OK

12345

it doesn't really work out if I put in a certain word as a delimiter.

Thank you for your help in advance!

FinnCharlton

I've attached the workbook so you can have a look, the expression I've used is:(.+City)\s(.+?)\s(.+)

The marked groups are in brackets.

Also, there are plenty of RegEx tutorials online to help you understand what this expression is doing.