ExcelBanter - Need to remove hyphen in group of #s

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Need to remove hyphen in group of #s (https://www.excelbanter.com/excel-discussion-misc-queries/15660-need-remove-hyphen-group-s.html)

[email protected]

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

tina

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

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

-----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?

All times are GMT +1. The time now is 05:54 AM.