How to replace word in Excel

image_pdf

Here, let's discuss about how to replace data in Excel workbook using Replace command. The shortcut for Replace is Ctrl+H

If you want to quickly find specific text in Excel from database, then find feature is very useful

1. Press Ctrl+H.

2. Provide name which you want to search. Also, mention the name which you want to replace.

For example, here we want to replace "Shruti" with "Ankita".

Find and Replace

Click on "Replace All" to replace all the occurrences of name "Shruti" with "Ankita".

If you want to check before replacing text then click on Replace. It will find your search and replace it one by one.

Explore more, It's Amazing

Replace space between two words with underscore

900 total views, 1 views today

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>