Export Test Results To Excel Sheet

You are correct. In most cases, surrounding the values with quotes is enough to allow commas. I actually forgot about that step in my discovery process and so I didn't mention it in my post above.  Some of the text I was processing already had quote marks (measurements, e.g. 2 1/2") so that messed up my plan so I ended up doing what I mentioned above.



So... a quick summary for those that come later...

1. 
   If you don't have commas or quotes in your values, you can just separate all values with commas. e.g. value1,value2, value3


2. 
   If you have commas (but not quotes) in your values, you can surround those strings with quotes. (This is probably just good practice anyway to avoid the oops later) e.g. "$1,200","$1,400","$1,600"


3. 
   If you have quotes in your strings, pick a different separator value that will never show up in one of your values. e.g. 2 1/2"|3"|3 1/2" (where | is the separator)

If you don't have to use #3, you can save the text file with the CSV extension and Excel will open it as is. If you have to use #3 then you will have to use Excel's text import wizard to specify the separator value... it's not that hard but it's an extra step. I ended up writing a quick Excel macro to do the import for me.