Convert Text-Formatted Fraction (4 / 4) to Percent %?

**WilyTrader** · 04-01-2010, 04:30 PM

I have a number of cells that currently have formulas that output text-fractions ie: "3 / 4" (with space before and after /). I am trying to convert these to a % ie: 75%

I've tried using
* ="="&C9 but this outputs '=3 / 4' as text
* =FIXED(C9,0,TRUE) but this outputs the numeric date quivalent of 40272
* A number of different variants using Indirect() but keep getting #REF! errors

I'm trying to do this without VBA if at all possible.

Any suggestions?

WT

**shg** · 04-01-2010, 04:33 PM

Why not modify the formula that outputs those value to eliminate the spaces and return a numeric result?

**JeanRage** · 04-01-2010, 04:35 PM

Hi,

=LEFT(A1,1)/RIGHT(A1,1)

and format as percentage ...

HTH

**darkyam** · 04-01-2010, 05:08 PM

Or, if either numerator or denominator exceeds 9, =LEFT(A1,FIND(" ",A1)-1)/RIGHT(A1,LEN(A1)-FIND("/",A1)-1).

**martindwilson** · 04-01-2010, 09:03 PM

you could get away with
=LEFT(A1,FIND(" ",A1)-1)/RIGHT(A1,2) as there always is a space after /

**darkyam** · 04-01-2010, 09:06 PM

Perhaps, but I'm a fan of handling all cases when possible. 1041 / 7123 would be handled by mine and we don't really know the OP's true requirements for the formula.