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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Melissa - 28 Apr 2006 21:34 GMT

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

Reply to this Message

Rae Drysdale - 28 Apr 2006 21:41 GMT

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.

Signature

Rae Drysdale

> I'm trying to delete a single space between a group od items:
>
[quoted text clipped - 3 lines]
>
> Thanks

Reply to this Message

Trevor Shuttleworth - 28 Apr 2006 21:42 GMT

Melissa

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

Regards

Trevor

> I'm trying to delete a single space between a group od items:
>
[quoted text clipped - 4 lines]
>
> Thanks

Reply to this Message

Melissa - 28 Apr 2006 21:58 GMT

It says that " " can not be located?

> Melissa
>
[quoted text clipped - 12 lines]
> >
> > Thanks

Reply to this Message

Dave Peterson - 29 Apr 2006 01:20 GMT

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

> It says that " " can not be located?
>
[quoted text clipped - 14 lines]
> > >
> > > Thanks

Signature

Dave Peterson

Reply to this Message

Cutter - 28 Apr 2006 21:48 GMT

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

Reply to this Message

Melissa - 01 May 2006 13:35 GMT

Got It !! Thanks that was great help.

> Have you tried Find/Replace method?
>
[quoted text clipped - 6 lines]
>
> This replaces the space with nothing

Reply to this Message