Hi,
I have a spreadsheet where text in column I contains comments. In these comments I have reference numbers which are sometimes entered incorrectly.
Comments may include:
TCN95384 A4891644922
A4884103393 ABANDONED IN STORE
ABANDONED AT DC A4864666884
A4655177099 no carrier number
The reference starting with 'A' always has 10 numbers following it as can be seen.
Is there a way to highlight the row if the reference has more/less than 10 numbers to highlight the error?
Duplicate post
https://www.excelforum.com/excel-for...highlight.html
as I was looking to solve this with formula so I can use conditional formatting, if anyone can do this then I'd be interested to see how it works in my situation
Thanks
Bookmarks