Thanks for the help, everyone. It works.

"Ron Coderre" wrote:

Try this:

For text in A1

B1: =SUBSTITUTE(A1," ","")
Removes ALL spaces

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"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