Hello guys;
I have an issue with a file coming from a database, it contains some 'zero-length strings' and all the fields that are supposed to be 'blank' are not. My file has hundreds of thousands of rows and 135 columns, so using the method 'find & replace' for sometehing like '$$$$' just causes excel to crash and it never completes.
I found online that if you do 'text to columns' ('Delimited' > uncheck all 'Delimiters' and select '{none}' as the 'Text qualifier') for each column it makes the problem go away. I tried manually with one column and it works, but I'm trying to build a macro to just repeat the 'text to columns' for each of the columns I have in the same sheet in my spreadsheet, but I just can't find a way online to build that macro, any ideas?
I added a sample file, in row 4 I added a formula so you can see those columns where the zero-lenght strings exist.
Thanks a lot for your help!
Luis