I have a column of numbers in the format 99999-99999. What is a simple macro to remove the dash?
I have a list of 3215 product names on a spreadsheet. Each resides in a single cell. I need to put each name in quotes. The names are all in one column?
I have created some clever formulas, and I don not want anyone else to see them. Is it possible to hide the formulas but display the results?
Excel uses for the indirect and address functions or formulas?
Somehow, my worksheet has external links to files that are no longer around. How can I delete the links?
In order to apply the same formatting to every sheet in a workbook in ms-excel what needs to be done?
Differentiate between count, counta, countif, and countblank in ms-excel.
What is the difference between substitute and replace function in ms-excel?
How can the users return to any particular area of a worksheet?
What is the role of cell reference in the calculation in excel?
What is if function in excel?
What are pivot tables and also mention its use?
In how many formats is a report available in excel?
Can a pivot table use multiple sources of data?
What are the useful functions in microsoft excel?