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!