Replace space between two words with underscore

image_pdf

1. If you have column with name and surname with space between them and now you want to remove this space and add underscore (_) between these two words, then Find and Replace is useful.

For example, In B column we have Ankita Shah, which we want to replace with Ankita_Shah and same for all in selected cells.

2. Press Ctrl+H. In "Find what" dialog box provide one space and in "Replace with" dialog box provide underscore (_). Click on "Replace All".

Result:

You can see that all the spaces have been replaced with _.

Explore more, It's Amazing

Use "Replace All" to quickly find and replace text with another text in Excel

22,503 total views, 24 views today

One thought on “Replace space between two words with underscore

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>