Need formula to remove double space

[zarab]

Hello I have a list of names that i need to remove double spaces between each word so there is only one space between each word any help is apperciated

[Debraj Roy]

Unlike Rtim or Ltrim..
TRIM function can remove spaces from .. Left Right and Double space in between Words.. in a cell..
Try

=TRIM(A1)

[ramananhrm]

This will remove all the double spaces.

=TRIM(SUBSTITUTE(SUBSTITUTE(A1," ","*"),"*"," "))

[zarab]

=TRIM(SUBSTITUTE(A1," ","*")) worked but for some reason it doesnt trim all the values I had to do trim first then substitute

[L-Drr]

you could also do it without a formula, by using the replace and find option (Ctrl+H) and finding " " (2 spaces) and replacing them with " " (one space). maybe do this again if there are instances with 3 spaces (first time 3 becomes 2, second time 2 becomes 1)