Thanks for all of your help and suggestions. I ended up figuring out how to
do it with a non excel solution. I used edit replace in notepad to change
all of the jibberish into html table tags then I saved it as a .html opened
it with internet explorer and copied and pasted the table into excel

"Pete" wrote:

This file is slightly different (easier) than that pointed to in the
link in your original post - in that you had combinations like
"|&quot and ;< which made it more difficult to see the
pattern. Following on from Brian's suggestion, you want to
Find <ProductMaster Name=
Replace with Line Break
as you don't need the text. Similarly,
Find <Product Grade=
Replace with , (comma), and
Find <Grade SKU=
Replace with ,

This way you can build up a csv file quite quickly and then bring it
into Excel.

Pete