count the number of digits ISBN : 0524102434

[Max Bialystock]

I need to find a way to count the number of digits in cells that contain
information such as "ISBN : 0524102434".

If the number of digits is not 10 or 13 then the ISBN is not valid.

The digits, may sometimes, include an X.

 

[Stefi]

Say ISBN No. is in A1, then
=LEN(TRIM(SUBSTITUTE(SUBSTITUTE(A1,"ISBN",""),":","")))

Regards,
Stefi

„Max Bialystock†ezt írta:

 

[Roger Govier]

Hi Max

Assuming all entries start with "ISBN: " i.e. 6 characters, then
=IF(OR(LEN(A1)=16,LEN(A1)=19),"OK","Incorrect")