Deleting a space between a group of Numbers & Letters in a cell

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

Guest

I'm trying to delete a single space between a group od items:

ACE 12408 ------------I'm looking for ACE12408

I have over 10,000 lines so I'm looking for a shortcut.....Help ME please!!!

Thanks
 
Highlight the text, go to Edit | Replace. In the Find what box just press the
spacebar and then click Replace All, ie don't put anything in the Replace
with box.
 
Melissa

why not just use a global Replace of " " for "" (nothing)

Regards

Trevor
 
Have you tried Find/Replace method?

Highlight all your cells containing the data to alter
Go to Edit > Find
In the space for "Find What" type a space
For the "Look In" drop down choose values
Click on "Replace"
Then click on "Replace All"

This replaces the space with nothin
 
If that didn't work, then maybe those characters aren't space characters.

If you copied from a web page, you could have those non-breaking HTML spaces
(char(160)'s) in your data.

You could try this:
Select the range
edit|Replace
what: hit and hold the alt key while typing 0160 on the numeric keypad
with: (leave blank)
replace all

If you have to do this kind of stuff lots of times, you may want to try David
McRitchie's routine to clean the data:

http://www.mvps.org/dmcritchie/excel/join.htm#trimall
(look for "Sub Trimall()"

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
 
Back
Top