View Single Post
  #1   Report Post  
 
Posts: n/a
Default Need to remove hyphen in group of #s

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