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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A2,CHAR(190),"3/4"),CHAR(189),"1/2"),CHAR(188),"1/4")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Text fraction to fraction format 1
Extract numerator from fraction 9
How do I Format fractions as fraction characters in Excel 2003? 1
How do I display fractions in small characters? 1
How do I type a fraction in `Word`without using super/sub script 3
How do I change a text fraction. eg 1 1/2 into a decimal number, . 1
how do I change fraction display that is not automatically change 1
How do I get excel to NOT auto reduce fractions. 2

Back
Top