Hello Everyone. I am trying to create a sum calculation that will ignore the inch symbol that is in a cell such as cell A1 = 42" and cell A2 = .25, I am trying to create a calculation without using vba that will ignore the inch symbol (") in cell A1 and just multiply the value of 42 times the value in cell A2. Is there a simple way to do this?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Simple sum ignoring inch symbol
- Thread starter tm1274
- Start date
Similar threads
- Question
