ExcelBanter - count the number of digits ISBN : 0524102434

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - count the number of digits ISBN : 0524102434 (https://www.excelbanter.com/excel-programming/377383-count-number-digits-isbn-0524102434-a.html)

Max Bialystock[_2_]

count the number of digits ISBN : 0524102434

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

count the number of digits ISBN : 0524102434

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

Regards,
Stefi

€žMax Bialystock€ ezt Ã*rta:

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.

Roger Govier

count the number of digits ISBN : 0524102434

Hi Max

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

--
Regards

Roger Govier

"Max Bialystock" wrote in message
...
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.

All times are GMT +1. The time now is 02:16 AM.