Hi,
Got the code for superscript and subscript and thought of sharing here.
This macro assumes that you will have 3 cells selected prior to calling it.
Once run, it will ask you to select Target cell for output.
Public Sub ValueTolerance2()
Dim rngSel As Range, rngTgt As Range
Set rngSel =...
One more thing I found is : If value in any input cell is edited after running the macro, the result will be same as before. Associativity is not there after editing the input cells.
Thank you both. Really I am learning new things from you. As a design engineer it is a big challenge for me to get results like this in excel. You guys inspired me to learn a lot.
Thanks for your unconditional love :)
It works fine. Thank you very much for your time and effort. Really your help is highly appreciated.
Now,I got some idea and will try to do with any row and any column which can select the particular 3 cells required and give the output with superscript and subscript.
Thanks a ton.
Regards,
Ravi
Hi SkipVought,
I have gone through the file. Thanks for your effort and time.
Sorry,the camera option won't work for the requirement as we need output in single cell with +0.2 as superscript and -0.1 as subscript next to 20.
Thanks a lot for the help anyway.
Hi all,
Again came with some query as I tried a lot and not able to get the result.
Question is there are 3 cells in excel with inputs like 20 in 1st cell, +0.2 in 2nd cell, -0.1 in third cell. we need a Macro or UDF to get output in a single cell with 20 and +0.2 as superscript, -0.1 as...
Hi Denial,
My inputs will be like 10.350 Dia, R 5.50 like that and I need to get output by removing text with 10.350 and 5.50 so on.
The output should be exactly with all numbers in input including zeros after decimal places as these values will be inspected for measuring components.
Hi IDS,
In that =ExtractNums function, for values like 1.230, 1.350 e.t.c, the output is 1.23 and 1.35.
Not able to get full decimals values including zero.
Can you please help on that?
HI IDS,
Sorry for the late reply as I was on leave these days.
I tried ExtractNums, it was helpful.
Thank you very much for the support and your time.
Regards,
Ravi
Hi IDS,
I have seen your post, I tried to implement here and not getting the output.
Getting compile error after using the formula =NumericOnly.
Thanks for your post and effort to solve my problem.
Regards,
Ravi
Dear IRStuff,
I repeatedly saying, I am Design engineer and new to excel.
I am trying something to do in Excel for inspecting dimension values.
I evaluated the formula for upper value and came to know that if some character is before the value, it will print all the number and if not, it will...
Hi,
I need to print upper and lower values from alpha numeric cell by skipping alphabet.
Input will be like :
Major 2.00
Minor 1.00 R in a single cell ( 2.00 then alt+enter 1.00 R)
Output should be 2.00 and 1.00 in other 2 cells by skipping alphabet.
I am using the following formulae. But...
Hi All,
I am Design engineer and very new to excel. Need some help for conversion of formula to userform or button for quick access.
Below are the formulae need to be converted.
For condition 1 :
1. Nominal value : LEFT(B2,FIND("±",B2)-1)
2. Upper Tolerance ...
Hi SkipVought,
As I am Design engineer and very new to excel, took the help of this forum.
Thanks for the support and I got solution.
I will continue the next plan converting these formulae to userform by help of colleagues here.
Once again thank you very much eng-tips and supporters.
Regards...
Hi SkipVought,
Sorry for the inconvenience. I will take care in future to avoid this kind of misunderstandings. Deleting this thread as the problem solved from other thread.
