Excel Macro

CANCELLED
Bids
32
Avg Bid (USD)
\$297
Project Budget (USD)
\$250 - \$750

Project Description:
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.

Skills required:
Excel
Qualifications required:
US English - Level 1
Additional Files:
Project ID: 5042936
Report Project
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.

\$ 360
in 5 days
\$ 277
in 2 days
\$ 250
in 3 days
\$ 250
in 1 days
\$ 263
in 2 days
\$ 320
in 2 days
\$ 277
in 3 days
\$ 250
in 2 days
\$ 250
in 10 days
\$ 250
in 3 days