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

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

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

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

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

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

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

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

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

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

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

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

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

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