Remove Space in Text

T

Tian

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
 
K

Kevin B

Formula example assumes that the value you want to strip the spaces from is
in A1:


=SUBSTITUTE(A1," ","")
 
R

Ron Coderre

Try this:

For text in A1

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

Does that help?

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

XL2002, WinXP-Pro
 
T

Tian

Thanks for the help, everyone. It works.

Ron Coderre said:
Try this:

For text in A1

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

Does that help?

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

XL2002, WinXP-Pro
Click to expand...
 
Top