I'm analysing a large datasheet of over 80k rows which extends over 7 columns A-G. Data are grouped into sets which are separated by one empty row. Data sets vary dramatically in size which is the number of their rows.
ColD is the main working area at the moment, where it contains strings with two colours: black and red.
Red portion of each cell's string should all be red to enable further analysis, but, in fact, there are some invisible black spaces in that red portion of the cell string which cause errors in my analysis.
What I am after is to test all cells red portion of the text and if there's any invisible black spaces, then cells should be highlighted in yellow.
I've attached a simple example, in which Sheet1 contains three manually created black spaces in the red portion of diffferent cells, and Sheet2 is the required result after detecting the errors.
Can I get some precious help with this problem, please?
Many thanks in advance ..
T.
Bookmarks