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

Previous QuestionNext Question
Hey! Excel used to have letters to indicate the columns. Now, all of a sudden, there are numbers for the columns?Is there a way to determine the last active column in a spreadsheet?