I am trying to import information into a new excel file. The original information is a series of numbers separated by dashes. I want all of the numbers, none of the dashes but I want to keep the zeros. Everything I try dumps the zeros.
Example: 3-0573-0188-03-6
Desired result: 305730188036
Any ideas?
Thanks!
Example: 3-0573-0188-03-6
Desired result: 305730188036
Any ideas?
Thanks!