Thread: NEED EXCEL FORMULA TO CONVERT 13 DIGIT ISBN TO 10 DIGIT ISBN
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Don_Quixote60[_2_] Don_Quixote60[_2_] is offline
external usenet poster
  
Posts: 1
Default NEED EXCEL FORMULA TO CONVERT 13 DIGIT ISBN TO 10 DIGIT ISBN
Afraid it's not that easy.

"JE McGimpsey" wrote:

One way:

A1: 978-3456789012

A2: =RIGHT(A1,10)

In article ,
Don_Quixote60 wrote:

I HAVE ALREADY FOUND A FORMULA TO CHANGE 10 DIGIT ISBN NUMBERS TO 13 DIGIT
BUT I NEED A FORMULA TO CHANGE 13 DIGIT TO 10

Reply With QuoteReply With Quote