Take a look here and use Dave McRitchie's Trimall macro. Put a copy of it in
your Personal.xls and you will then be able to use teh routine on any sheet you
are working on. It will do the lot in a heartbeat.

http://www.mvps.org/dmcritchie/excel/join.htm#trimall

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



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

Edwin


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



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.560 / Virus Database: 352 - Release Date: 08/01/2004