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.

--
Rae Drysdale


"Melissa" wrote:

> 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

Melissa

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

Regards

Trevor


"Melissa" <(E-Mail Removed)> wrote in message
newsB979E99-C349-4D77-8681-(E-Mail Removed)...
> 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

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

--
Cutte
-----------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...nfo&userid=984
View this thread: http://www.excelforum.com/showthread.php?threadid=53736

It says that " " can not be located?

"Trevor Shuttleworth" wrote:

> Melissa
>
> why not just use a global Replace of " " for "" (nothing)
>
> Regards
>
> Trevor
>
>
> "Melissa" <(E-Mail Removed)> wrote in message
> newsB979E99-C349-4D77-8681-(E-Mail Removed)...
> > 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
>
>
>

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" <(E-Mail Removed)> wrote in message
> > newsB979E99-C349-4D77-8681-(E-Mail Removed)...
> > > 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

Got It !! Thanks that was great help.

"Cutter" wrote:

>
> 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 nothing
>
>
> --
> Cutter
> ------------------------------------------------------------------------
> Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
> View this thread: http://www.excelforum.com/showthread...hreadid=537364
>
>