MS Excel cleanup routine

mmblz · 07-11-2012, 11:49 AM

or use regexp - see the second answer here:
http://stackoverflow.com/questions/3...ction-or-regex

to remove anything but digits use \D instead of \d

markem · 07-11-2012, 12:12 PM

Thanks, Julian. Looks like trim() will work, but I also played with the regex routine you pointed me to.

07-11-2012, 11:49 AM	#1
mmblz .090909... Join Date: Oct 2008 Location: NH Posts: 4,031 Trading: (3)	Re: MS Excel cleanup routine or use regexp - see the second answer here: http://stackoverflow.com/questions/3...ction-or-regex to remove anything but digits use \D instead of \d __________________ herf wear

07-11-2012, 12:12 PM	#2
markem Bunion Join Date: Oct 2008 First Name: Mark Location: Second Star on the Right Posts: 22,660 Trading: (47)	Re: MS Excel cleanup routine Thanks, Julian. Looks like trim() will work, but I also played with the regex routine you pointed me to. __________________ I refuse to belong to any organization that would have me as a member. ~ Groucho Marx