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

Deleting the spaces before and after a number in Excel 97
 

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

Deleting the spaces before and after a number in Excel 97
 

thanks a lot -that seems to work wel

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

Deleting the spaces before and after a number in Excel 97
 

I use it all the time - saves soooooooooooooo much effort. :-)

--
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
...
thanks a lot -that seems to work well


---
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

Deleting the spaces before and after a number in Excel 97
 

Buzz,

I just formatted a column as text, and entered space 1 space and space 2
space and added them and it worked fine. The only thing I had to do was do
the sum in another column, otherwise the formula was read as text.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"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/

Deleting the spaces before and after a number in Excel 97
 

Select the column and do Edit=Replace, Replace What - space, Replace with -
leave it blank. Unless the spaces are char(160), you don't need a macro.

--
Regards,
Tom Ogilvy

"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/