I have to edit urgent html text files with macro. I tried to import html file into excel but the text file is broken into parts according cell size. The view is the same but I have to add the cells content to have the original line.
How to solve this job? Any ideas appreciated.
Here's an example that will read your input into Excel, more "properly".
Open in new window
See attached demonstration workbook.