How to remove space within a string through Excel Functions

[faurburg24]

Dear Lists,

I hope to know any function or embeded function which could help to remove space (' ') within a string.

For example
Before: Din ner
After: Dinner.

Thanks,
Viesta

[amy_d2]

Hi & welcome to the forum

You can use this

=SUBSTITUTE(D8," ","")

where your word "Din ner" is in cell D8

[Rambo4711]

Or mark the range of cells you want to change. Choose "Find and replace"
Find: " " (only a blank character)
Replace with: NOTHING (no character)

[faurburg24]

Thanks, A!
That's a really good idea and much helpful to me!