# Thread: Dividing fractions into new cell Thanks: 0 Likes:  3 Post #5315641 (2)Post #5315625 (1)

1. ## Dividing fractions into new cell

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.

2. ## Re: Dividing fractions into new cell

Hey,

B2: =36/164
C2: =B2

Then format C2 as a percentage with 2 decimals

Is this what you are after?

3. ## Re: Dividing fractions into new cell

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}))

4. ## Re: Dividing fractions into new cell

Hi

What do you have in A2

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

or

The text value: 36/164

?

5. ## Re: Dividing fractions into new cell

Another way:

 A B C 1 2 36/164 0.2195122

 Cell Formula C2 =--LEFT(B2,FIND("/",B2)-1)/--MID(B2,FIND("/",B2)+1,16)

6. ## Re: Dividing fractions into new cell

For a text value I'd use:

=("0 "&A1)+0

7. ## Re: Dividing fractions into new cell

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

8. ## Re: Dividing fractions into new cell

Originally Posted by pgc01
For a text value I'd use:

=("0 "&A1)+0
Nice

M.

9. ## Re: Dividing fractions into new cell

Originally Posted by dsacomano
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.