This content has been marked as final. Show 8 replies
If I understand correctly, you are concerned about how the design table looks in your drawing. For that you can covert the useful part of the text to a number. For example, for a symetrical tolerance, create another column and use the formual =VALUE(MID(A1,12,4)) where "A1" equals the cell where the tolerance appears. That will grab the tolerance to 3 places and convert it to a number value. You can then format the cell to what you want. Hide the column you don't want to see.
This is starting to look good!! I still need a bit more help though..
Can I do the same with my bilateral values? if so how?
You said, "You can then format the cell to what you want".
Did you mean I can format the cell to get the +/- sign in that cell?? Or how would you recommend get the signs?
I'm not used to using excel, let alone tables and formulas...
below is a screen shot of how my table looks, as you can see I've converted the one symmetrical cell according to your instructions.. but need help with the bilateral and the signs...
thank you so much for your help!!
So where cell A1 contains . . .
make a cell containing . . .
and another containing . . .
I hope you can figure out the code, enough to make any changes you want.
Admit... it did take me a few and the assitance of a co-worker to figure out the code... LOL
I think I've got it now!! Looks much better than before.
Thank you very much for your help!!
YES......... Dwight!! You're a GENIUS!!!!
I got it...... with the formula...
I even got everything in one cell!!!
By George, she's got it . . .
Can you post an example of the CONCATENATE you did for the bilateral tolerances in the design table? I think this will work for me, but I want to make sure before i spend the time. I need the tolerances to show up in one cell like you say this has done for you.
SW 2008 sp4.0
Attached is a sample table.
Later I hid the column with the original tolerances.