Recent content by raviprakash369

Hi, Can anyone please help me how to create 3d pdf from Nx PMI models? Thanks in advance. Regards, Ravi

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 :)

@ Doug Jenkins, I have tried the code posted and getting error "cannot execute code in break mode"

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

Yes, the number you have written is the exact output looking for.

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 IDS, Thank you very much for your support and time. Really your post was very helpful. your support is highly appreciated.

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...