software

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 Drysdalequot;Melissaquot; wrote:

gt; I'm trying to delete a single space between a group od items:
gt;
gt; ACE 12408 ------------I'm looking for ACE12408
gt;
gt; I have over 10,000 lines so I'm looking for a shortcut.....Help ME please!!!
gt;
gt; Thanks

Melissa

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

Regards

Trevorquot;Melissaquot; gt; wrote in message
news
gt; I'm trying to delete a single space between a group od items:
gt;
gt; ACE 12408 ------------I'm looking for ACE12408
gt;
gt; I have over 10,000 lines so I'm looking for a shortcut.....Help ME
gt; please!!!
gt;
gt; Thanks

Have you tried Find/Replace method?

Highlight all your cells containing the data to alter
Go to Edit gt; Find
In the space for quot;Find Whatquot; type a space
For the quot;Look Inquot; drop down choose values
Click on quot;Replacequot;
Then click on quot;Replace Allquot;

This replaces the space with nothing--
Cutter
------------------------------------------------------------------------
Cutter's Profile: www.excelforum.com/member.php...foamp;userid=9848
View this thread: www.excelforum.com/showthread...hreadid=537364It says that quot; quot; can not be located?

quot;Trevor Shuttleworthquot; wrote:

gt; Melissa
gt;
gt; why not just use a global Replace of quot; quot; for quot;quot; (nothing)
gt;
gt; Regards
gt;
gt; Trevor
gt;
gt;
gt; quot;Melissaquot; gt; wrote in message
gt; news
gt; gt; I'm trying to delete a single space between a group od items:
gt; gt;
gt; gt; ACE 12408 ------------I'm looking for ACE12408
gt; gt;
gt; gt; I have over 10,000 lines so I'm looking for a shortcut.....Help ME
gt; gt; please!!!
gt; gt;
gt; gt; Thanks
gt;
gt;
gt;

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:

www.mvps.org/dmcritchie/excel/join.htm#trimall
(look for quot;Sub Trimall()quot;

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

Melissa wrote:
gt;
gt; It says that quot; quot; can not be located?
gt;
gt; quot;Trevor Shuttleworthquot; wrote:
gt;
gt; gt; Melissa
gt; gt;
gt; gt; why not just use a global Replace of quot; quot; for quot;quot; (nothing)
gt; gt;
gt; gt; Regards
gt; gt;
gt; gt; Trevor
gt; gt;
gt; gt;
gt; gt; quot;Melissaquot; gt; wrote in message
gt; gt; news
gt; gt; gt; I'm trying to delete a single space between a group od items:
gt; gt; gt;
gt; gt; gt; ACE 12408 ------------I'm looking for ACE12408
gt; gt; gt;
gt; gt; gt; I have over 10,000 lines so I'm looking for a shortcut.....Help ME
gt; gt; gt; please!!!
gt; gt; gt;
gt; gt; gt; Thanks
gt; gt;
gt; gt;
gt; gt;

--

Dave Peterson

Got It !! Thanks that was great help.

quot;Cutterquot; wrote:

gt;
gt; Have you tried Find/Replace method?
gt;
gt; Highlight all your cells containing the data to alter
gt; Go to Edit gt; Find
gt; In the space for quot;Find Whatquot; type a space
gt; For the quot;Look Inquot; drop down choose values
gt; Click on quot;Replacequot;
gt; Then click on quot;Replace Allquot;
gt;
gt; This replaces the space with nothing
gt;
gt;
gt; --
gt; Cutter
gt; ------------------------------------------------------------------------
gt; Cutter's Profile: www.excelforum.com/member.php...foamp;userid=9848
gt; View this thread: www.excelforum.com/showthread...hreadid=537364
gt;
gt;