Microsoft Excel – Find and replace text

In todays post we will go through removing blank cells within a spreadsheet, to achieve this you will need to carry out the steps listed below:

1. Start by highlighting the range of cells where the text you are wanting to replace may exist.
2. Within the ‘Home‘ tab click on ‘Find & Select‘ and then click ‘Replace…‘ within the dropdown menu.
3. In the new window that appears enter in the ‘Find what:‘ the text you are wanting to replace and enter in the ‘Replace with:‘ the text you are wanting in place instead.
4. Then click on the ‘Replace All‘ button.
5. A pop up will then appear notifying you how many replacements have been made, click ‘OK‘ then click ‘Close‘.