Translations:Basic Excel/200/en

Follow these steps:

  1. Select a range of cells that contains the data to be replaced (this saves Excel looking for, and replacing, data in other places).
  2. Select 'Temukan & Pilih' from the 'Mengedit' section of the 'Rumah' tab of the Ribbon, then choose 'Ganti' (or use CTRL+H).
    Find and replace (2)
  3. In the 'Temukan dan Ganti' dialog box, type ')' in the 'Temukan apa:' box, and leave the 'Ganti dengan:' box empty.
    Find and replace (3)
  4. In this case, we choose to click 'Ganti Semua'.
    • Excel makes the replacements, then tells us how many replacements were made. We click 'OK' to close this information message.
    • If there has been a mistake: remember that previous actions can be reversed using CTRL+Z!