I copy and paste into Excel but the numbers are being registered as text.I would like the numbers converted so that Excel recognizes them as numbers, and i can use mathematical equations on them.I race bicycles and these numbers represents each [url removed, login to view] is five columns(3/2H 23°/3Q 3°/3 4/5 4/15T).I want to break each column number up into two columns. I would like to make one column for the number(s) before the / and another column for the number(s) behind the /. The letters represent a fraction(H=1/2,Q=1/4,T=3/4,)So instead of 3/2H in one cell i would get 3 in one cell and 2 1/2 in the adjoining cell(I was 3rd,2 1/2 lengths behind leader).I want to be able to compute how many places i lost/gained during a race and how many lengths i lost gained.
The degree symbol (°)has no purpose but i would like something to represent it so i know it was [url removed, login to view] BOLD in the cell where the (°)used to be!
The letters behind the / is the only letters i am concerned with since they represent fractions(Q=1/4,H=1/2,T=3/4,HD,NK,NS=1/7(1.5).Letters like DIS-x don't mean anything so they can stay the same.
I have attached file with comments on J5.
Have a nice day.
31 freelancers are bidding on average $297 for this job
Hi Ken. I have looked at the attachment and I can manage the desired output for you in a way you want. Lets begin and get the work done. Hoping to read back from you. Regards
I am an excel and vba expert. I work with it there is about 4 years. I am a statistician engineer working as a database manager. This job is what i master a lot.
Hi, I can help you with this rather quickly, and my policy is you only pay if you're happy with the solution. Looking forward to accepting my bid so I can start on t right away