VB excel reading comma as line break

[jzellman]

I have a VB program that imports old Fixed Width text files into Excel. Works great until there is a comma in one of the text fields. At that point it starts a new line right in the middle of the record.

Is there a way to ignore or delete the comma?

Thanks

 

[Joe4]

Duplicate: https://www.mrexcel.com/forum/excel-questions/1038533-vb-remove-comma-inside-text-field.html

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).