divide numbers within a cell

		Microsoft Office Forums > Microsoft Excel > Excel
divide numbers within a cell

FAQ

Thread Tools

Display Modes

06-04-2017, 06:55 AM

ewso

Windows 10 divide numbers within a cell

Office 2016

Advanced Beginner

Join Date: Nov 2016

Posts: 80

divide numbers within a cell

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

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 11:26 AM.