 |
 | 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 / May 2008formatting
Hello, does anyone know how I can look at a cell without seeing a special character? I need to determine a length by subtracting one cell from another but the numbers in the cell are engineering stationing in the format xxx+xx.xx (300+45.10). I need to use this data to get the number 30045.10 to then subtract from another cell of the same type. With your sample entry in cell A1... Try this: B1: =--SUBSTITUTE(A1,"+","") If A1 contains 300+45.10 that formula returns 30045.1 Does that help? Post back if you have more questions. -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) > Hello, does anyone know how I can look at a cell without seeing a special > character? I need to determine a length by subtracting one cell from [quoted text clipped - 3 lines] > to > then subtract from another cell of the same type. Another thought, using the same approach to calculate differences. With A1: 300+45.10 A2: 200+29.40 This formula removes the plus signs and returns A1 minus A2. A3: =SUBSTITUTE(A1,"+","")-SUBSTITUTE(A2,"+","") In the above example, A3 returns: 10015.7 Does that help? -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) > With your sample entry in cell A1... > Try this: [quoted text clipped - 21 lines] >> to >> then subtract from another cell of the same type. That worked perfect. Thanks, John > Another thought, using the same approach to calculate differences. > [quoted text clipped - 42 lines] > >> to > >> then subtract from another cell of the same type. You're welcome.....I'm glad I could help. Regards, Ron Microsoft MVP (Excel) > That worked perfect. Thanks, John > [quoted text clipped - 46 lines] >> >> to >> >> then subtract from another cell of the same type. |
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.