# 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

Project ID: #5042936

## 31 freelancers are bidding on average \$297 for this job

jeweljitu

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

\$360 USD in 5 days
(142 Reviews)
6.4
nagybatonyi

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)
5.6
seaanddream

\$250 USD in 3 days
(47 Reviews)
5.5
vbexcel

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)
5.3
sonarkaushik

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

\$263 USD in 2 days
(20 Reviews)
5.1
maverick44000

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)
4.7
dpune

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)
4.5
elMancha

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)
4.5
Kryptora

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)
4.2
jaylancer43

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)
4.0
Edison1983

*******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)
3.7
excel4engineers

Thanks Ken for your clear instructions. Regarding your comments: 1-"column I to R is where I would like the [url removed, login to view] 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)
3.4
inoussakabore

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)
3.3
MimiFL

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)
3.2
tomislav1975

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)
3.1
drevak

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

\$277 USD in 3 days
(2 Reviews)
2.9
zExcel

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)
2.7
rpedersen360

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)
2.1
BhargaviR05

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)
1.2
amitchaps

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)
1.0