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

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!

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

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!

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

Francis Hayes
www.TheExcelAddict.com

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!

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!


.