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

[Melissa]

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

 

[Rae Drysdale]

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.

 

[Trevor Shuttleworth]

Melissa

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

Regards

Trevor

 

[Cutter]

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

 

[Melissa]

It says that " " can not be located?

Melissa

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

Regards

Trevor

 

[Dave Peterson]

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

 

[Melissa]

Got It !! Thanks that was great help.