View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Buzz88 Buzz88 is offline
external usenet poster
 
Posts: 1
Default Deleting the spaces before and after a number in Excel 97

Hi, I have Excel 97, and am trying to analyse some results from a
online survey, which has been stored on a database (MySQL). To get th
details into Excel, I highlight the details on the website, and past
them in Excel. Unfortunately, phpMyAdmin adds a space before and afte
the number, so I cannot add the results together without manuall
deleting the space before and after the number. As I have over 80
results, this could take some time. Has anyone got an idea for a macr
that would do this for me? I am no expert in Excel, so the simpler th
better! Thanks in advance,

Edwi

--
Message posted from http://www.ExcelForum.com