first 0
Do you mean find its position in the string?
=FIND("~",SUBSTITUTE(A1,"0","~",LEN(A1)-LEN(SUBSTITUTE(A1,"0",""))))
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"delmac" wrote in message
...
Hi all ihave a column of numbers like
00022230013A
00111110007A
00044440132A and I need to find the first 0 from the right in each number,
can anyone please help. Ta.
--
delmac
|