Deleting unwanted lead spaces throughout a worksheet
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.
|