removing all spaces
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? |
removing all spaces
=SUBSTITUTE(A1," ","")
-- Gary''s Student gsnu200711 |
removing all spaces
One way:
=SUBSTITUTE(A1," ","") In article , jamesea wrote: 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? |
removing all spaces
How about just selecting the range to fix and
Edit|Replace what: (spacebar) with: (leave blank) replace all jamesea wrote: 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? -- Dave Peterson |
removing all spaces
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. "Dave Peterson" wrote: How about just selecting the range to fix and Edit|Replace what: (spacebar) with: (leave blank) replace all jamesea wrote: 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? -- Dave Peterson |
All times are GMT +1. The time now is 04:19 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com