View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Coles2020 Coles2020 is offline
external usenet poster
 
Posts: 7
Default 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.