Excel formula to remove space between words in a cell

0 votes
I've a huge data in excel file.

For eg: say i've a word like paul son,i've to make it as paulson.

input:paul son output:paulson.

In some cells ,i've data like mic-li,when this type of words come,it should not replace any thing,it should only remove spaces in between words.
Mar 28, 2022 in Database by Edureka
• 13,690 points
• 2,391 views