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 wrote:

It says that " " can not be located?

"Trevor Shuttleworth" wrote:

Melissa

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

Regards

Trevor


"Melissa" wrote in message
...
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




--

Dave Peterson