View Single Post
Old 07-11-2012, 11:23 AM   #3
markem
Bunion
 
markem's Avatar
16
 
Join Date: Oct 2008
First Name: Mark
Location: Second Star on the Right
Posts: 22,649
Trading: (47)
HUpmann
markem has disabled reputation
Default Re: MS Excel cleanup routine

Thanks, Michael. However, I am trying to take a cell with a number that looks like "123 " (note the space at the end) and removes all non-numbers to get "123" (no space). It's easy to do in C, since isanumber is there. There are specific instances where the number might not be terminated by a space, so I can't just delete the last character of the string. Also, I suspect that sometimes, that space is a tab.
__________________
I refuse to belong to any organization that would have me as a member.
~ Groucho Marx
markem is offline   Reply With Quote