How to remove text from a cell in Excel

You can watch a video tutorial here.

The format of a spreadsheet in Excel is in the form of columns and rows. Each intersection of the row and column is a cell. When you type some text, it gets stored in a single cell until you press Enter. Here we will look at ways of removing text from a single cell or multiple cells.

Option 1 – Edit the cell

Step 1 – Enable the cell for editing

  • Select the cell and press F2
  • Alternatively, select the cell and place the cursor in the formula bar
  • Select the unwanted text and press Delete

OR

Position the cursor at the end of the word and press Backspace

Step 2 – Check the result

  • The text has been removed

Option 2 – Use Find and Replace

Step 1 – Open the Find and Replace window

  • Go to Home > Find & Select > Replace

OR

Click Ctrl+F

Step 2 – Replace the word

  • Select the Replace tab
  • Type the word to be replaced under Find what:
  • Leave Replace with: blank
  • Click Replace all

Step 3 – Check the result

  • The text has been removed