=substitute(a1," ","")

replaces all the spaces in A1 with nothing.



Tian wrote:

I know how the "trim" function works, but is there a function in excel to
remove all the space in text? Example would be

from "281P 358" to "281P358"

Thanks

--

Dave Peterson