Dear BobBridges



Thanks for your great help and it is really useful. we would better to use
VBA because a lot of data will involved. attached pls find the new question file which
i actual face and solve. We need your expert help. The answer will show in column
13 to 18. also there is some head,neck involved instead of number. how to do

thanks for your great help
Tom

Attached Files

new qustion.xls (21.0 KB, 10 views)

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.