count the number of digits ISBN : 0524102434

's Computer Specifications

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.

's Computer Specifications

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.
>
>
>
>

's Computer Specifications

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" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
>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.
>
>
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
urgent : count of digits in a number	=?Utf-8?B?U0hJUkE=?=	Microsoft Excel Programming	4	26th Apr 2006 09:19 PM
ISBN Check Digits	Colin Vicary	Microsoft Excel Misc	3	12th Aug 2005 04:12 PM
I need to count the digits of a number	Jimmy	Microsoft Access Queries	1	9th Feb 2004 10:16 AM
I need to count the digits of a number	Jimmy	Microsoft Access Getting Started	1	9th Feb 2004 10:16 AM
Need a formula to count the number of digits in a number.	=?Utf-8?B?SkVUSFdB?=	Microsoft Excel Worksheet Functions	2	24th Jan 2004 06:01 AM