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

20,370 total views, 4 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>