 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / January 2008Need to convert the numbers with tolerances
I have a column of numbers in teh format 0.45+_0.23 . +_ is a character plus or minus . How can I convert the number before and after +_ into mm automatically ? Any formula ? - Vijay v_udupa@hotmail.com > I have a column of numbers in teh format 0.45+_0.23 . +_ is a > character plus or minus . > How can I convert the number before and after +_ into mm > automatically ? Any formula ? I presume the "numbers with tolerances" are actually in Text format. Depends on the exact format of the number strings. If they are the 4 characters on the left and right, then: =value(left(A1,4)) =value(right(A1,4)) If the length of the numeric strings vary, then: =value(left(A1, find("+",A1)-1)) =value(right(A1, len(A1) - find("+",A1))) where "+" is the plus-or-minus character that you mention. Your question is not entirely clear to me. Assuming you actually have +_ as your characters between the numbers, then... Lower Number: =LEFT(A10,FIND("+",A10)-1)-MID(A10,FIND("_",A10)+1,255) Higher Number: =LEFT(A10,FIND("+",A10)-1)+MID(A10,FIND("_",A10)+1,255) If you are using this symbol ± instead, then use it in place of both the "+" and "_" in the above formulas. If the _ is really a minus sign, then use that instead of the _ in the above formulas. Rick >I have a column of numbers in teh format 0.45+_0.23 . +_ is a > character plus or minus . [quoted text clipped - 3 lines] > - Vijay > v_udupa@hotmail.com Yes what you have tried to say is not entirely clear - perhaps an IF statement? >I have a column of numbers in teh format 0.45+_0.23 . +_ is a > character plus or minus . [quoted text clipped - 3 lines] > - Vijay > v_udupa@hotmail.com Hi Rick and Joe, Both the solutions worked well for my problem. Thanks very much for teh quick reply rgds Jambar > Yes what you have tried to say is not entirely clear - perhaps an IF > [quoted text clipped - 7 lines] > > - Show quoted text - |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.