Perhaps a sample of your data would allow greater flexibility in arriving at a
solution?


Gord Dibben MS Excel MVP

On Sun, 1 Apr 2007 11:46:01 -0700, Don_Quixote60
wrote:

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