Dear Bobbridges,
Yes u know my situation attached pls find the new questions excel files.
1. yes u are right want the superscripted part Then, if the superscript isn't a numeric value, we want back just the string without being changed. Yes retrun the string if
dont do any calculation at all
2. Actually i dont fully understand because i only attend 10hr vba course but i trust you have expert ability to do this excise
3. at this moment , the most important is that i can get the vba code to do my
routine work as file attached. Then i will study step by step later. As a matter
of fact at least i can do my job to boss in time without delay. haha
I my abiltiy i believe i cannot do such complex progamme, we really
need your help
Thanks
Tom