Microsoft Excel Question: Download Questions PDF
I have a column of numbers in the format 99999-99999. What is a simple macro to remove the dash?
Answer:
You don't need a macro. Highlight the column and use Edit - Replace. In the "Find What", enter a dash. Leave "Replace With" blank. Click "Replace All".
Download MS Excel Interview Questions And Answers
PDF