Closed

Excel Macro

This project received 32 bids from talented freelancers with an average bid price of $297 USD.

Get free quotes for a project like this
Employer working
Skills Required
Project Budget
$250 - $750 USD
Total Bids
32
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 [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.

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online