Need help with math Function

W

wytedragn

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 loo
like this(22/8, 45/6, 313/9, etc.) you get the point. What I am aske
to do is go through this colum and change each one to a whole numbe
(ex. 22/8 would be changed to 23, 45/6 is changed to 46). Basicall
what I want to do to save so much time(and I'm not sure if this i
possible) is to make a function that will find the fraction, fo
instance 22/8, multiply it by the bottome number (8) and then add 1.
really hope someone can help. If i'm unclear, let me know and I wil
try to explain better. Thanks sooo much in advance
 
R

Roger Govier

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 Special>Values

--
Regards

Roger Govier


"wytedragn" <[email protected]>
wrote in message
news:[email protected]...
 
W

wytedragn

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.
 
Top