![]() |
|
#1
|
|||
|
|||
|
I have a spreadsheet with two numbers in the same cell, like this... A1: $1.24(1.5) A3: $2.35(1.6) A5: $0.32(1.1) I need to be able to divide the first number by the number that's in parentheses throughout the whole document. The parenthesis is right next to the first numbers without any space in between. Can this be done? Thanks |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Add only first numbers in each cell | ewso | Excel | 9 | 05-24-2017 09:43 AM |
| Difference between 2 numbers in same cell | Neila1982 | Excel | 1 | 02-12-2017 01:40 AM |
Add Numbers from One or Another Cell
|
Kilch | Excel | 3 | 01-31-2017 12:55 PM |
| Search a cell that contains words and numbers and convert the numbers to metric | Carchee | Excel Programming | 36 | 10-08-2014 03:16 PM |
adding numbers in same cell
|
jetdude68 | Word Tables | 1 | 07-20-2010 12:30 AM |