OK. You could do two Replaces followed by a Text to Columns. For
instance,

1) replace all "%" with "^$^REPLACE_ME^$^" (or some other unique phrase)
2) replace all "EXCLUDES" with "%"
3) Data/Text to Columns, splitting at "%"
4) replace "^$^REPLACE_ME^$^" with "%"





In article ,
"Rose" wrote:

Because my text can and does include spaces, commas, semicolons, tabs, and
every character on my keyboard - hence a mass Find and Replace will not work.
I need to find a string of text within my cell and parse it there.