Removing a keystroke
 

Is there a way to remove all spaces within a column of cells? Extra spaces
are screwing up my subtotals. Thanks!

Removing a keystroke
 

Select the cells to want to fix and then use Find/Replace
--
Gary''s Student - gsnu200909


"HeatherJ" wrote:

Is there a way to remove all spaces within a column of cells? Extra spaces
are screwing up my subtotals. Thanks!

Removing a keystroke
 

Select the column
Edit|replace
what: (space character)
with: (leave blank--not even a space character)
replace all

But....

Did you get this data from a web site?

If yes, then you could be seeing those non-breaking HTML spaces.

You can clean them up with formulas, but if you have to do it lots of times (or
with lots of data), you may want to use a macro.

David McRitchie has a macro that can help clean this:
http://www.mvps.org/dmcritchie/excel/join.htm#trimall
(look for "Sub Trimall()")

If you're new to macros:

Debra Dalgleish has some notes how to implement macros he
http://www.contextures.com/xlvba01.html

David McRitchie has an intro to macros:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Ron de Bruin's intro to macros:
http://www.rondebruin.nl/code.htm

(General, Regular and Standard modules all describe the same thing.)

HeatherJ wrote:

Is there a way to remove all spaces within a column of cells? Extra spaces
are screwing up my subtotals. Thanks!

--

Dave Peterson

Removing a keystroke
 

Select your column
Edit/ Replace:
Find what: [type a space]
Replace with: [leave empty]
Replace All
--
David Biddulph

"HeatherJ" wrote in message
...
Is there a way to remove all spaces within a column of cells? Extra
spaces
are screwing up my subtotals. Thanks!

Removing a keystroke
 

Do you want to delete blank rows? Select the cells, press F5, Special,
Blanks, OK. Then Delete etnire rows.

Francis Hayes
www.TheExcelAddict.com

Removing a keystroke
 

Extra spaces or all spaces? Ctrl + h then find what hit the space and
replace with leave blank will remove all spaces

To remove extra spaces use either the TRIM function with a help column and
then copy and paste special over the old entries or use a macro like TRIMALL
from here


http://www.mvps.org/dmcritchie/excel/join.htm#trimall


how to install here

http://www.mvps.org/dmcritchie/excel...la.htm#install



--


Regards,


Peo Sjoblom


"HeatherJ" wrote in message
...
Is there a way to remove all spaces within a column of cells? Extra
spaces
are screwing up my subtotals. Thanks!

Removing a keystroke
 

wonderful! thanks so much for responding.
Heather

"David Biddulph" wrote:

Select your column
Edit/ Replace:
Find what: [type a space]
Replace with: [leave empty]
Replace All
--
David Biddulph

"HeatherJ" wrote in message
...
Is there a way to remove all spaces within a column of cells? Extra
spaces
are screwing up my subtotals. Thanks!


.