I am new to this forum and I really hope someone can help.
I have a spreadsheet with a colum that has tons of fractions that look
like this(22/8, 45/6, 313/9, etc.) you get the point. What I am asked
to do is go through this colum and change each one to a whole number
(ex. 22/8 would be changed to 23, 45/6 is changed to 46). Basically
what I want to do to save so much time(and I'm not sure if this is
possible) is to make a function that will find the fraction, for
instance 22/8, multiply it by the bottome number (8) and then add 1. I
really hope someone can help. If i'm unclear, let me know and I will
try to explain better. Thanks sooo much in advance.


--
wytedragn
------------------------------------------------------------------------
wytedragn's Profile: http://www.excelforum.com/member.php...o&userid=35918
View this thread: http://www.excelforum.com/showthread...hreadid=557105

Hi

Assuming your data starts in A1, enter the following in B1
=(LEFT(A1,FIND("/",A1)-1))+1
Copy down as far as required
To "fix" the data, copy the whole of Column B, then Paste SpecialValues

--
Regards

Roger Govier


"wytedragn"
wrote in message
...

I am new to this forum and I really hope someone can help.
I have a spreadsheet with a colum that has tons of fractions that look
like this(22/8, 45/6, 313/9, etc.) you get the point. What I am asked
to do is go through this colum and change each one to a whole number
(ex. 22/8 would be changed to 23, 45/6 is changed to 46). Basically
what I want to do to save so much time(and I'm not sure if this is
possible) is to make a function that will find the fraction, for
instance 22/8, multiply it by the bottome number (8) and then add 1. I
really hope someone can help. If i'm unclear, let me know and I will
try to explain better. Thanks sooo much in advance.


--
wytedragn
------------------------------------------------------------------------
wytedragn's Profile:
http://www.excelforum.com/member.php...o&userid=35918
View this thread:
http://www.excelforum.com/showthread...hreadid=557105

Wow! I can't thank you enough. I had a feeling I was in the right forum.
I am temping for a company and I just saved a guy here soo much time. He
was doing it one by one, all they way down the column, and there is a
lot of them. Thanks again.


--
wytedragn
------------------------------------------------------------------------
wytedragn's Profile: http://www.excelforum.com/member.php...o&userid=35918
View this thread: http://www.excelforum.com/showthread...hreadid=557105