1.

How To Replace One Value With Another In Excel?

Answer»
  • You can REPLACE one value with ANOTHER using the FIND & REPLACE feature in EXCEL.
  • To do this, select the data SET and use the keyboard shortcut - CONTROL H (hold the control key and then press H). This will open the Find & Replace dialog box.
  • In this dialog box, you can specify the value you want to change and the REPLACEMENT value.



Discussion

No Comment Found