Replace Space Between Two Words with Underscore

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

For example, In B column we have Amazing Excel, which we want to replace with Amazing_Excel and same for all in selected cells.


replace-spae-between-two-words-in-excel

 

Press Ctrl+H (Find and Replace Shortcut Key). In Find and Replace dialog box look for “Find what” option and provide one space and in “Replace with” dialog box provide underscore (_) and Click on “Replace All” button.

 

find-and-replace-to-replace-space-with-underscore

 

Result:

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

repaced-space-with-underscore-result

Click Here to Leave a Comment Below 0 comments

Leave a Reply: