Excel Numerator Demonimator Splitting

Assume 140/70 is located in cell A1 these formula will then split it up for you :)

[cell B1] =FIND("/",A1,1) //Finds the position of the division line
[cell C1] =LEFT(A1,B1-1) // Extracts only the data to the left of the division line
[cell D1] =RIGHT(A1,LEN(A1)-B1) // Extracts only the data to the right of the division line
 
Last edited:
Are they just numbers in cells with no formulas behind them?

Id use text to columns personally. Highlight the column, and select the text to columns option (think its in data on the menu bar) Use the delimited option, and set the seperator as / or manually set your own.

Will take two seconds, and seperate the sets of numbers into thier own columns.
 
You must log in or register to reply here.
Back
Top Bottom