The above explained code is working 99.9% as expected.![]()
Please Login or Register to view this content.
However, if i enter the exact same text in Column J(Column 10), but one in sentance case, and the other in CAPITALS, I do not have BOTH populated.
Is there a line of code i can add to check the actual font capitalisation also to rectify this?
Bookmarks