Excel Macro

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.

Skills: Excel

See more: excel macro how to, lost excel, h symbol, excel format cell, excel cell format, excel 2013 macro, lap, excel copy format file, excel text column, excel text columns, excel column copy, copy cell cell excel macro, macro excel format, bicycles, macro format, macro copy excel paste, number excel macro, excel macro columns, copy paste macro, excel columns text file macro

About the Employer:
( 7 reviews ) Canada

Project ID: #5042936

31 freelancers are bidding on average $297 for this job


Hello,i am excel programming expert!!! like macro,visual basic macro,formula,vba [login to view URL] you interested please knock [login to view URL]

$360 USD in 5 days
(142 Reviews)

I plan to complete the project via writing an Excel macro contained in a separate XLSM file. This approach makes further use of the macro very convenient by offering a Control sheet containing cells populated by the u More

$277 USD in 2 days
(48 Reviews)

Hi; your 5-star excel and vba coding expert is ready to help you.. kindly check my profile and feedbacks first...

$250 USD in 3 days
(47 Reviews)

I am an Excel / VBA coder pro with over ten years experience in developing automated Excel applications. The solution you are looking for is quite simple. I would write a macro to do the conversion. Your bid categor More

$250 USD in 1 day
(26 Reviews)

Sir, I am well versed in this kind of jobs and can do your project as per requirement. Refer my online work portfolio at [login to view URL] Looking for further discussions in this matter. with than More

$263 USD in 2 days
(20 Reviews)

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

$320 USD in 2 days
(14 Reviews)

Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 200 projects. Please look at my feedback to know more about me and my work. Waiting for more details along with posi More

$277 USD in 3 days
(13 Reviews)

Hello there. I have high Excel and Visual Basic skills with great professionalism. I study electronics and computer engineering at Oporto university and I'm looking for work to fill the blanks on my schedule. Fo More

$250 USD in 2 days
(22 Reviews)

Hello, I am a VB (6.0 / .NET), VBA and VSTO software developer. I have five years of experience in programming. I rest-assure that I will complete the work on time and deliver you the completed work to your satisfactio More

$250 USD in 10 days
(14 Reviews)

Hello - I am an expert techno-functional analyst having vast experience in lots of arenas of IT industry including Excel Macros. I am an Engineering Graduate with an MBA degree. If you see, I am among the niche bid More

$250 USD in 3 days
(17 Reviews)

*******I've done Similar Projects*********************** Good Day!.. I'm a VBA Programmer, having 6+ years of exp. Have developed & designed various excel based projects, dashboards, templates and trackers by using E More

$250 USD in 0 days
(11 Reviews)

Thanks Ken for your clear instructions. Regarding your comments: 1-"column I to R is where I would like the [login to view URL] bold format in K2:N2 is for the now missing degree symbol." IT IS OK 2-"I have left co More

$250 USD in 1 day
(9 Reviews)

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.

$250 USD in 3 days
(2 Reviews)

Well hi, i m serious freelancer with 100% completion rate (you can check my profile by clicking on my name), this macro isn't hard, i would suggest doing this: First, i would create a macro that will fill your table More

$250 USD in 3 days
(3 Reviews)

Hello, I'm familiar with such calculations and I can solve this. Please chek my reviews and award me with trust. With tegards, Tom

$250 USD in 5 days
(3 Reviews)

-------------------------------------Consider it done...done professionally!----------------------------

$277 USD in 3 days
(2 Reviews)

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

$250 USD in 3 days
(2 Reviews)

Hello! First, thank you for posting such a detailed project description. The work required is extremely clear, along with your example in the spreadsheet. I am an Excel expert and have a very large amount of exp More

$250 USD in 1 day
(1 Review)

We are well experienced programmers and we can sort this out easily. We already served similar macros to UK clients and Portuguese clients too.

$277 USD in 1 day
(3 Reviews)

Hi, This is Amit from Illuminatus Softwares,India. We have expertise in excel development & have executed multiple such projects. We can handle row based modifications & will be delivering the project in a seam- More

$444 USD in 4 days
(1 Review)