Excel Macro

Avg Bid (USD)
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:
Qualifications required:
us_eng_1 US English - Level 1
Additional Files: bicyclecharting.xlsx
Hire kkaren
Project posted by:
kkaren Canada
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
Hire nagybatonyi
$ 277
in 2 days
$ 250
in 3 days
$ 250
in 1 days
$ 263
in 2 days
Hire maverick44000
$ 320
in 2 days
$ 277
in 3 days
$ 250
in 2 days
$ 250
in 10 days
$ 250
in 3 days