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.

--
Hth

Kassie Kasselman
Change xxx to hotmail


"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.