How do you find and replace multiple values at once in excel?



How do you find and replace multiple values at once in excel?..

Answer / Amit Gautam

"To find and replace multiple values at once, use the Find & Replace dialog box with the 'Replace' tab selected. Click on Replace All, then enter the values to be replaced and their replacements (separated by a semicolon)."n

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More MS Excel Microsoft Interview Questions

What is goal seek in excel?

1 Answers  


How do you format numbers in excel?

1 Answers  


How do I calculate wacc in excel?

1 Answers  


How do I switch first and last names in excel?

1 Answers  


What is the difference between a column break and a page break?

1 Answers  


How To Protect The Macros You Create So People Cannot See Or Alter Them?

1 Answers   Microsoft,


When I open a workbook, excel asks if I want to update the links. I have looked everywhere, and I can not find any links in my formulas?

1 Answers  


How do you edit a named range in excel?

1 Answers  


How can I vary the width in the columns of a spreadsheet?

1 Answers  


How do I fix #value error in excel?

1 Answers  


What is meant by data consolidation in excel?

1 Answers  


How do I jump to a specific sheet in excel?

1 Answers  


Categories