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