removing all spaces

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

Guest

I have a list of company names in excel and need to remove all spacing. e.g.
"care homes ltd" needs to be "carehomesltd" if there a formula that will
remove this spacing?
 
How about just selecting the range to fix and
Edit|Replace
what: (spacebar)
with: (leave blank)
replace all
 
One last thought on removing spaces from Excel: If the spaces are normal
spaces, use Ctrl+H (Replace), "Find What": [enter a single 'space' here]
"Replace With": [leave blank] will work fine. HOWEVER, if the spaces are
"protected spaces" (e.g., Ctrl+Shift+space), that procedure WILL NOT WORK.
Use the same procedure above, but instead of entering a single 'space' under
"Find What", you must enter Alt+0160 (using the numbers on the NumPad only).
You can't see "protected spaces" in Excel (you can copy and paste a section
into word and click on the Paragraph Icon to see if the spaces are
protected... they will appear as little circles instead of dots). Good luck.
P.S. Thank you "Cliff" for the latter tip.
 

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 Hi, I want to add or remove spaces between initials in an Excel 2007 spreadsheet 0
How can I remove blank spaces from fields 6
Space removal - a first name,space last name 2
remove spaces in front of text 2
Removing blank spaces from the ends of email fields? 2
TRIM Help ! 8
removing a single space in a cell 4
Formula Needed - Truncate extra spaces at end of variable text len 1

Back
Top