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.



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.





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


Click Here to Leave a Comment Below 0 comments

Leave a Reply: