Thread: divide numbers within a cell
View Single Post
 
Old 06-04-2017, 03:53 PM
ewso ewso is offline Windows 10 Office 2016
Advanced Beginner
  
Join Date: Nov 2016
Posts: 80
ewso is on a distinguished road
Default
Quote:
Originally Posted by xor View Post
In B1 try:

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

Thanks xor, it works!
Reply With Quote