How do I remove all spaces in a text string

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

Guest

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

Before: AA 123 ZZ
After: AA123ZZ

Excel 2003

Thanks,
dn
 
Or even select the range first
and edit|replace
what: (spacebar)
with: (leave empty)
replace all.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel, custom format 5
Excel Subtract text after the third space and before the fourth (from between spaces) 3
Copy and replace 1
How fill cells with alpha series? 3
removing a single space in a cell 4
convert a text string to a number 7
Remove text 5
Remove characters from a text string using a formula 1

Back
Top