Quote Originally Posted by Paul_Hossler View Post
If it's ALWAYS in the first position, something like this would work


=RIGHT(C11,LEN(C11)-1)

Otherwise you need something more complicated like Mac's
I finally managed to solve the matter by creating multiple VBA codes i.e MyClear1,2,3 etc and filtered a single cell via colomns, so eventually the cell gets caught to one of the error codes.

Thanks a lot for your support and time.