Verifying value of a cell
Hey there...
want to verify the structure of a value in a cel, since then I will use that
value for some other operations.
The value should allways be like AK456j912 That is: First and second and
sixth caracter a letter (Letters can be lower or upper), the rest numbers.
and want to return a messasge if it is not that structure. If it has the
structure, then apply the formula...
value of cell other operations result
as123z456 9 2
aaa439n0 #VALUE #VALUE
8u7j999o2 #VALUE "check number"
If structure wrong, then result is check number (Other operation will be
#VALUE)
Thanx
|