One way:

=SUBSTITUTE(A1," ","")


In article ,
"dn" wrote:

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

Befo AA 123 ZZ
After: AA123ZZ

Excel 2003

Thanks,
dn