It sounds as if there is something very strange with your setup. It
ouightn't to do that. It'll be interesting to hear what's in the cells.
--
David Biddulph

"Coles2020" <Onward2000 wrote in message
...
Kassie
That didn't work at all. It just deleted all the cells I highlighted.

"kassie" wrote:

copy an empty cell on your worksheet. Now select the range with the
leading
spaces, right click, slect Paste Special, select the Add operation
option,
and OK out. That normally converts numbers written as text back to
numbers.

"Coles2020" wrote:

I have FrontPage email me the result of a survey form -- with both the
question and the response. If the person selects a particular question
the
result is "1". However, when I copy and paste the emailed results into
Excel
the "1" is preceded by several spaces so that I cannot perform any
calculations.

Is there an easy way to remove those leading spaces from all cells
(both
rows and columns) in my worksheets?

Thank you.