Text Editor

[jamiedavies02]

Does anybody know of a text editor that is Excel friendly?

Basically I have a scraper which downloads data into an Excel file, I would like to run it through a text editor which removes all formatting and paste it into a new Excel file whilst retaining rows and columns.

Thanks

 

[Joe4]

You wouldn't use a Text Editor to edit an Excel file. Text Edtiors are used to edit Text files (i.e. files typically with extensions like .txt, .csv, .tab, .dat, .prn).
If it is truly downloading it to an Excel file, you would use Excel to edit it. You can use VBA code (macros) to automate formatting clean-up.