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

dn wrote:

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

Befo AA 123 ZZ
After: AA123ZZ

Excel 2003

Thanks,
dn


--

Dave Peterson