I have a column of numbers in the format 99999-99999. What is a simple macro to remove the dash?
- 1 Answers
- 749 Views
- I also Faced
- E-Mail Answers
Answer / Brajesh Kumar Verma
In MS Excel, you can use a formula like `SUBSTITUTE(A1, "-", "")` to remove dashes from a cell A1. If you want to apply it to multiple cells, copy the formula across the desired range.
| Is This Answer Correct ? | 0 Yes | 0 No |
What are the types of excel functions?
What does the f3 key do in excel?
How do I copy and paste exact formatting in excel?
Why we use in excel formula?
How do I change the ribbon color in excel 2016?
How can I be good in excel?
How do you use the char function in excel?
How do you compare two excel sheets for differences in values vlookup?
How do you jump to the last tab in excel?
How do you keep a cell constant in a formula?
How do I resize an excel spreadsheet?
What is the limit of excel rows?
MS Excel Microsoft 
