I have a spreadsheet covering A to THG, and 1000+ rows deep.
WHen I use COUNTA on a row, its counting "blank" cells. All cells (when it has been exported" have come as "TEXT".
It will take a long time (and have another sheet about 20x as big with the same issue.
TEXT TO COLUMNS works but will take an age going through each column individually.
Is there either a macro I can have do this (starting column M through to THG?
(Have also use Replace "" with "+++++" but again, this solution will take an absolute age.
If I use
for example it comes up as #VALUE!
I am guessing a macro that could run doing the Text To Columns is the best solution? If so, ohw would I go about this.
Welcome to other ideas!
WHen I use COUNTA on a row, its counting "blank" cells. All cells (when it has been exported" have come as "TEXT".
It will take a long time (and have another sheet about 20x as big with the same issue.
TEXT TO COLUMNS works but will take an age going through each column individually.
Is there either a macro I can have do this (starting column M through to THG?
(Have also use Replace "" with "+++++" but again, this solution will take an absolute age.
If I use
Excel Formula:
=CODE(THG235)
I am guessing a macro that could run doing the Text To Columns is the best solution? If so, ohw would I go about this.
Welcome to other ideas!