| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count number of digits in a cell | Excel Worksheet Functions | |||
| Count number of digits (Numbers) | Excel Discussion (Misc queries) | |||
| NEED EXCEL FORMULA TO CONVERT 13 DIGIT ISBN TO 10 DIGIT ISBN | Excel Discussion (Misc queries) | |||
| urgent : count of digits in a number | Excel Programming | |||
| ISBN Check Digits | Excel Discussion (Misc queries) | |||
![Max Bialystock[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
