text strings

Hi Guys and Gals - Been awhile since I've been to the site. I'm now experimenting with macros. I currently use a DOS based program to decrease or increase an account receivable. I would like to use a macro, to record repetitive key strokes. The macro I use is working but I would like to...

Hi everyone, <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> I'm new using VB and I'm having some troubles to get data from a closed wb in Excel 2007, I found a code which I tried to use but doesn't work:<o:p></o:p>...

Looking for assistance in figuring out the best formula to extract the VOC content value from variable length alphanumeric string. The VOC content is the number just before the "g/L". I need to extract just the number portion just before the units “g/L”. Most of the time there is a space...

Is there a function that will drop values from a cell? In other words, do the opposite of the Left and Right functions. Instead of returning the first x characters in a cell, it drops the first x characters from a cell? If yes, can someone let me know what it's called and what arguments are...