divide numbers within a cell

ewso · #1 06-04-2017, 06:55 AM

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

xor · #2 06-04-2017, 11:37 AM

In B1 try:

=LEFT(A1,FIND("(",A1)-1)/MID(A1,FIND("(",A1)+1,FIND(")",A1)-FIND("(",A1)-1)

ewso · #3 06-04-2017, 03:53 PM

Quote:

Originally Posted by xor

In B1 try:

=LEFT(A1,FIND("(",A1)-1)/MID(A1,FIND("(",A1)+1,FIND(")",A1)-FIND("(",A1)-1)

Thanks xor, it works!

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