Need to remove hyphen in group of #s

[indymodeler]

I have a list of numbers as shown
12345-67
12354-58
15454-54
21544-54
I need a formula/macro or something that will allow me to remove the
hyphen.
1234567
1235458
1545454
2154454
Any ideas would be appreciated.
Lakedawgs

 

[tina]

Hi
Try this formula assuming 12345-67 in cell a1
=MID(a1,1,5)&MID(a1,7,2)
hope this helps
Tina

 

[Guest]

-----Original Message-----
I have a list of numbers as shown
12345-67
12354-58
15454-54
21544-54
I need a formula/macro or something that will allow me to remove the
hyphen.
1234567
1235458
1545454
2154454
Any ideas would be appreciated.
Lakedawgs

.
why cannot you use edit, find "-" and replace with

nothing?