Highlight the column, rows, or all cells and select Edit--Replace.
In the find what field, enter a space. In the replace with field,
enter nothing. If more options are not available, click the Options
button. Make sure Match entire cell contents in not checked. Click
Replace All. This will get rid of ALL spaces in the selected cells.
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.