Removing dashes from ISBN's while still keeping 1st number (zero)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have imported a list of ISBN's ( SKU) numbers into a spreadsheet so that I
may remove the dashes in between the 10 digit number. When I use the find
function in Excel, the dashes are removed. Unfortunately, along with the
dashes, the first digit of the ISBN is removed as well. This probably has
something to do with the fact that most ISBN's start with the number 0. Is
there any way I can remove the dashes quickly while keeping the 0's?
 
I have imported a list of ISBN's ( SKU) numbers into a spreadsheet so that I
may remove the dashes in between the 10 digit number. When I use the find
function in Excel, the dashes are removed. Unfortunately, along with the
dashes, the first digit of the ISBN is removed as well. This probably has
something to do with the fact that most ISBN's start with the number 0. Is
there any way I can remove the dashes quickly while keeping the 0's?
Click to expand...

=TEXT(SUBSTITUTE(A1,"-",""),"0000000000")


--ron
 
Edit > Replace
Find what:-
Replace with:leave it blank
Click Replace All

Custom Format 0000000000
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Displaying zeros in cells 2
Remove dashes from phone numbers in a spreadsheet 3
Remove dashes between letters and between letters and digits 7
how to remove dashes 2
Need to change numbers with dashes to numbers with no dashes 3
Numbers Converted to Text - Last Digit Replaced by Zero 14
Remove Dashes from Social Security Numbers 8
How to remove dashes in Social Security number 15

Back
Top