Need to remove hyphen in group of #s

I

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
 
G

Guest

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

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
Click to expand...
nothing?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I need to remove the hyphen in a list of #s 4
How to remove characters in a cell that precede a specific hyphen 17
Excel Removing the last 7 characters of cell in excel 0
Remove lines from text file prior to importing in Excel 3
I need to look for a number and return the column heading. 6
Function to put worksheet name in cell returns text, need number 5
how do I remove 0's from in front of a number. 00012 to 12 2
I need to remove passwords from a list of files. 4

Top