# 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

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

#### 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.

Threads
1,090,377
Messages
5,414,094
Members
403,515
Latest member
see_mido