count the number of digits ISBN : 0524102434

  • Thread starter Thread starter Max Bialystock
  • Start date Start date
M

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.
 
Say ISBN No. is in A1, then
=LEN(TRIM(SUBSTITUTE(SUBSTITUTE(A1,"ISBN",""),":","")))

Regards,
Stefi

„Max Bialystock†ezt írta:
 
Hi Max

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