# Dividing fractions into new cell

#### dsacomano

##### New Member
I am looking for a way to divide a fraction in one cell and put the percentage of that fraction into the next cell.

Example: B2- 36/164 C2- Percentage from B2 (36/164 = 21.95%)

Any help is greatly appreciated. Thanks.

### Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a \$25,000 loan, 5% annual interest, 60 month loan.

#### tyija1995

##### Well-known Member
Hey,

B2: =36/164
C2: =B2

Then format C2 as a percentage with 2 decimals

Is this what you are after?

#### Jon von der Heyden

##### MrExcel MVP, Moderator
If it's text you could try:

=LOOKUP(10^9,--LEFT(A1,{1;2;3;4;5;6;7;8;9}))/LOOKUP(10^9,--RIGHT(A1,{1;2;3;4;5;6;7;8;9}))

#### pgc01

##### MrExcel MVP
Hi

What do you have in A2

The formula: =36/164 that displays the number 0.2195...

or

The text value: 36/164

?

#### DanteAmor

##### Well-known Member
Another way:

<br /><table border="1" cellspacing="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:76.04px;" /><col style="width:76.04px;" /><col style="width:76.04px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td > </td><td >A</td><td >B</td><td >C</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >1</td><td > </td><td > </td><td > </td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >2</td><td > </td><td >36/164</td><td style="text-align:right; ">0.2195122</td></tr></table><br /><table style="font-family:Arial; font-size:10pt; border-style: groove ;border-color:#00ff00;background-color:#fffcf9; color:#000000; "><tr><td ><b></b></td></tr><tr><td ><table border = "1" cellspacing="0" cellpadding="2" style="font-family:Arial; font-size:9pt;"><tr style="background-color:#cacaca; font-size:10pt;"><td >Cell</td><td >Formula</td></tr><tr><td >C2</td><td >=--LEFT(B2,FIND("/",B2)-1)/--MID(B2,FIND("/",B2)+1,16)</td></tr></table></td></tr></table>

Last edited:

#### pgc01

##### MrExcel MVP
For a text value I'd use:

=("0 "&A1)+0

#### dsacomano

##### New Member
I have text in B2. DanteAmor, your formula worked perfect! Thank you all for your help!

#### DanteAmor

##### Well-known Member
I have text in B2. DanteAmor, your formula worked perfect! Thank you all for your help!
You're welcome, thanks for the feedback.
But, the pgc01 formula is better.

1,089,329
Messages
5,407,608
Members
403,154
Latest member
Tebrica