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!