How do I reformat fractions that are expressed in smaller font?

C

cwalton

How do I reformat fractions that are expressed in a smaller font than the
remaining text in an Excel cell? Reducer FTG x C 1-½" x ¾", we would like it
to read 1-1/2" x 3/4" for import into our accounting software package.
Thanks.
 
D

David Biddulph

=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A2,CHAR(190),"3/4"),CHAR(189),"1/2"),CHAR(188),"1/4")
 
Top