Converting fractions to decimals

richardthelionheart

Board Regular
Joined
Mar 25, 2016
Messages
89
I have data which looks like this -
9/4 JF
6/4 F
5/2 F
2/1 F
etc etc
Using this formula I can convert these to -
9/4
6/4
5/2
2/1

' =IFERROR(LEFT(T136,FIND("/",T136)+1),T136)

But what I'm really looking for is -
2.25
1.5
2.5
2

I'm happy to use an extra column to achieve my goal but
if it can be done in " One Go" that would be even better.
Any help would be gladly appreciated.
 

Some videos you may like

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce

gaz_chops

Well-known Member
Joined
Apr 29, 2003
Messages
6,256
Platform
MacOS
Must be a better way, but this appears to work

=LEFT(G2,FIND("/",G2&"/")-1)/MID(G2,FIND("/",G2&"/")+1,FIND(" ",G2&" ")-FIND("/",G2&"/")-1)
 

nemmi69

Active Member
Joined
Mar 15, 2012
Messages
457
Office Version
365, 2016, 2013
Platform
Windows
Have you tried formatting the cells as "General"?
 

Phuoc

Board Regular
Joined
Apr 29, 2016
Messages
189
One way:

=--("0 "&LEFT(A1,FIND(" ",A1)-1))
 
Last edited:

gaz_chops

Well-known Member
Joined
Apr 29, 2003
Messages
6,256
Platform
MacOS
You're welcome, although I would go with Phuoc's solution, maybe with a tweak in case there are no alpha characters after.

=--("0 "&LEFT(G8,FIND(" ",G8&" ")-1))
 

Watch MrExcel Video

Forum statistics

Threads
1,099,044
Messages
5,466,213
Members
406,473
Latest member
Dunno123

This Week's Hot Topics

Top