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.
Result:
You can now see that all the spaces have been replaced with _.