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".
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