How do I remove all spaces in a text string

dn · Nov 29, 2004

Simply stated, how would I remove all space in a text string.

Before: AA 123 ZZ
After: AA123ZZ

Excel 2003

Thanks,
dn

JE McGimpsey · Nov 29, 2004

One way:

=SUBSTITUTE(A1," ","")

Dave Peterson · Nov 29, 2004

Or even select the range first
and edit|replace
what: (spacebar)
with: (leave empty)
replace all.