I have a column of numbers in the format 99999-99999. What is a simple macro to remove the dash?
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”. Hey! Excel used to have letters to indicate the columns. Now, all of a sudden, there are numbers for the columns. You have Excel set up to use the R1C1 style of cell notation. Go to Tools > Options. Pick the General Tab. The first box in the settings section is checked (“R1C1 reference style”). Uncheck this box. Click OK. Your problem should be solved.
