How do I reformat fractions that are expressed in smaller font?
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A2,CHAR(190),"3/4"),CHAR(189),"1/2"),CHAR(188),"1/4")
--
David Biddulph
"cwalton" wrote in message
...
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.
|