Collection and sharing of, interview questions and answers asked in various interviews, faqs and articles.....
Excel : 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".
No comments:
Post a Comment