| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Deleting spaces | Excel Discussion (Misc queries) | |||
| Deleting spaces in blank cells | Excel Discussion (Misc queries) | |||
| Deleting leading spaces in a cell | Excel Discussion (Misc queries) | |||
| Deleting blank spaces in cells | Excel Discussion (Misc queries) | |||
| Inserting/Deleting Spaces | Excel Worksheet Functions | |||
Threaded Mode
