(Solved) – Identify if a cell with in text format contains any letters

(solved)-–-identify-if-a-cell-with-in-text-format-contains-any-letters

answer can be vba or formula but basically I have a list of around 12,000 identifying numbers that need to be stored as text to preserve leading 0s, and I use =len to identify any identifying numbers that are the wrong length, but I can’t work out how to quickly identify if a cell contains a letters.

=isnumber doesn’t work as the imported data is stored as text so says all cells aren’t numbers.

Any help much appreciated

Leave a Reply

Your email address will not be published. Required fields are marked *