| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 40423 | 2003-12-07 19:59:00 | XL Spreadsheet | B.M. (505) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 198196 | 2003-12-07 19:59:00 | I occasionally have a cell which reads say 1= this means that the competitor has dead heated for first. It could also read 2= or 3= etc. Now, it is imported in this format and somewhat confuses my spreadsheet. What I wish to do is drop the = sign and retain the number. Remember, this information is imported from another spreadsheet so it is quite ok to remove the = signs during importation. Any suggestions appreciated. |
B.M. (505) | ||
| 198197 | 2003-12-07 20:05:00 | You'll probably have to create a Macro to remove all the ='s, in case one occurs further down the list. | somebody (208) | ||
| 198198 | 2003-12-07 21:40:00 | Yes, there are a max 0f 188 rows and 4 columns and the = sign could appear in any cell or cells. Writing that type of macro could cause me grief. :D |
B.M. (505) | ||
| 198199 | 2003-12-07 21:44:00 | How about doing a find and replace to locate all the ='s and replacing them with nothing....unless of course you have = signs that you want to keep. | Barnabas (4562) | ||
| 198200 | 2003-12-07 22:52:00 | Good point, Didn't realise you could do that so I'll investigate further. |
B.M. (505) | ||
| 198201 | 2003-12-08 00:38:00 | All sorted. Thank you Umpire, Thank you Ballboys, Thank you everyone. |
B.M. (505) | ||
| 1 | |||||