You can do Edit/ Replace/ Alt0160/ [nothing]/ Close
Or =--SUBSTITUTE(A1,CHAR(160),"")
--
David Biddulph

"Coles2020" <Onward2000 wrote in message
...
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.