View Single Post
 
Old 02-01-2014, 02:14 PM
BobBridges's Avatar
BobBridges BobBridges is offline Windows 7 64bit Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

I think my solution last time was wrong. I thought you wanted it to calculate 5^(3 1/2), but you just want the superscripted part, 3.5. Then, if the superscript isn't a numeric value, you want back just the string without being changed. Is that right?

Still, you can modify my routine to make this work. Start by looking at the routine and see how it works. Then change it in this way: Detect whether the part of the text that is superscript can be viewed as a numeric value. 1) If it can, calculate the value (as I did), but return the superscript value rather than the base to that power. And 2) if it can't, don't do any calculation at all; just return the string.

I realize you may not know how to modify or even look at a worksheet function, such as the one I wrote for you in my last post. If so, don't worry; just tell me how much you understand, and I'll explain how to go on from that place.
Reply With Quote