creating a Macro 1

[angels1]

I am importing figures into an excel document they are coming in like 12-1234-78-924 I do not need the dashes in this file is there any way of removing these without going to each box individually I have 18 pages like this

 

[luceze]

Would find/replace work?

Eric

 

[angels1]

This will not work because each cell has a different value unless there is another way to replace each cell individually in rind and replace

 

[luceze]

What I meant was do a find and replace on the dash.

Find What: -
Replace With: ""

Under advanced options, select entire workbook. (Depending on Excel version)

You could do it in VB code but it would essentially do the same thing.

HTH,
Eric