ISBN 13 to 10 digit converter

[karankashyap]

Hi i need a formula of a excel file that converter my 13 Digit ISBN to 10 Digit ISBN

i am from India

Help

Thanks

 

[kvsrinivasamurthy]

Give some examples.

 

[mole999]

Excel Workbook
	A	B	C
1	1861972717	978186197271	9781861972712
Sheet1

 

[mole999]

I went the wrong way > https://www.mrexcel.com/forum/excel-questions/285670-isbn-13-10-conversion-macro.html

 

[karankashyap]

thanks
will try this

 

[karankashyap]

a book has it own unique code one is 13 digit and second is 10 digit

so i have 13 Digit Book Code or ISBN i need its 10 digit code

and their are too many books witch i need to convert the 13 digit isbn to 10 digit isbn

so need a converter

Thanks

 

[mole999]

dug out from the link i posted

=SUBSTITUTE(TRIM(SUBSTITUTE(MID(C1,4,LEN(C1)-4),"-"," "))," ","-")&IF(MID(C1,LEN(C1)-1,1)="-","-","")&SUBSTITUTE(MOD(990-SUMPRODUCT((11-ROW($1:$9))*MID(MID(SUBSTITUTE(C1,"-",""),4,9),ROW($1:$9),1)),11),10,"X")

 

[karankashyap]

dug out from the link i posted

=SUBSTITUTE(TRIM(SUBSTITUTE(MID(C1,4,LEN(C1)-4),"-"," "))," ","-")&IF(MID(C1,LEN(C1)-1,1)="-","-","")&SUBSTITUTE(MOD(990-SUMPRODUCT((11-ROW($1:$9))*MID(MID(SUBSTITUTE(C1,"-",""),4,9),ROW($1:$9),1)),11),10,"X")

my friend i am not expert can u please explain it how do i use this please step by step guide

 

[mole999]

your 13 digit number in C1, add that somewhere in your sheet on the same row, and just drag down. If you need a different cell, change the C1 in the formula to the cell you want to start from

 

[karankashyap]

your 13 digit number in C1, add that somewhere in your sheet on the same row, and just drag down. If you need a different cell, change the C1 in the formula to the cell you want to start from

Thankyou

thats work for me

you are great