I have a column of numbers in the format 99999-99999. What is a simple macro to remove the dash?

Submitted by: Administrator
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".
Submitted by: Administrator

Read Online Microsoft Excel Job Interview Questions And Answers