Remove Space in Text

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Formula example assumes that the value you want to strip the spaces from is
in A1:


=SUBSTITUTE(A1," ","")
 
Try this:

For text in A1

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

Does that help?

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

XL2002, WinXP-Pro
 
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...
 
Back
Top