Hello,

I'm dealing with CSVs that are pipe delimited. When I open the file in Excel, all the data fills in to column A, but if there is a comma anywhere in that row's worth of data, it bumps that data to column B, removing the comma. This creates a problem when I try to convert text to columns.

Is there a setting in Excel or elsewhere such that when I open a pipe delimited CSV that contains commas, it doesn't treat the commas as delimiters?

Thanks