We are preparing an Excel workbook file that must be saved as a CSV (several columns by at least 200 rows. Excel 2000.) Column D contains html (an html page) in each cell. With the html present, the file will not save correctly as a CSV but instead will place the entire contents into cell A1.
All hard line breaks in the html text must also be removed. We can already do this separately in Word but a quicker solution is desired.
We are looking for the quickest solution with the least number of steps possible.
Payment to be made only after we have tested solution.
Thanks to all in advance.