David
Thank you. The result was that those spaces are "non-breaking". Any idea on
how to get rid of those?

"David Biddulph" wrote:

=code(LEFT(A1)) will give you the ASCII code for the first character of the
string.
32 for a space. 160 for a non-breaking space.
--
David Biddulph

"Coles2020" <Onward2000 wrote in message
...
JW
I did this but was told there was nothing to replace. Does that mean that
the spaces before my "1"s are something else (i.e., tabs, etc.)?

"JW" wrote:

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.