Importing problem

[nana2six]

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!

 

[2rrs]

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!

Have you tried the replace feature?

go to edit replace:
replace what -

replace with: "leave this blank"

 

[nana2six]

The Find and Replace does not work, it does not leave it the way it is needed.

The original file looks like this:

3-0573-0188-03-6

and this is the desired result:

305730188036

Any other ideas?

 

[Mombuca]

Hi, try this:

cell A1 = "3-05......" create a macro with:

cVar=split(range("A1").value,"-")
for nI=0 to ubound(cVar)-1
cResult=cResult & cVar(nI)
next
range("A2").value=cResult

Ok ?

 

[2rrs]

Hmmm,

I just tried the replace feature with this: 3-0573-0188-03-6



and it returned this: 305730188036

 

[Wayne L.]

If you want to use an Excel function, SUBSTITUTE should work.