You have chosen to sponsor your bid up to a maximum amount of .
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 lap.There 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 there.Format 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.