Project Detail

Macro for use in Excel 2000

Macro for use in Excel 2000 is project number 190984
posted at Freelancer.com. Click here to post your own project.

| More

Status:

Selected Providers: hiratariq

Budget: $30-100

Created: 10/30/2007 at 17:57 EDT

Bid Count: 10

Average Bid:
$ 39

11/09/2007 at 17:57 EST

Project Creator: AlanB
Employer Rating: 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 (5 reviews)

Description

This project is for a macro to be used in Excel 2000.

We use the Excel new web query function to download columns of names, never more than fifty, some of which contain apostrophes (eg King's Head). The names can comprise several words, there can be more than one apostrophe and an apostrophe can appear at any point, including after the final letter of the name, eg How's She Cuttin'.

One source from which we download uses a diagonal apostrophe (`), rather than a vertical one ('), and this needs to be changed before the data is entered in our database.

We would therefore like a macro which, when applied to the selected column of names, identifies any apostrophes and changes them to vertical ones. Thus How`s She Cuttin` would become How's She Cuttin'.

Report Violation

Job Type

See more: data, download, excel, letter, macro, project, query, source, web

Messages Posted:2

If you are the project creator or one of the bidders Log In for more options

PMB

1 day

10-30-2007 21:47 EDT

9.881/10
(168 reviews)

Hello,Please check your PMB.Thank you.

skilledsir

0 days

10-30-2007 21:57 EDT

9.9474/10
(19 reviews)

hi,sir,i can do it for u ,i am online now ,we can chat here now. looking forward to your reply

hiratariq

1 day

10-30-2007 23:47 EDT

10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10
(18 reviews)

Please see PM

dren

0 days

10-30-2007 18:12 EDT

9.9/10 9.9/10 9.9/10 9.9/10 9.9/10 9.9/10 9.9/10 9.9/10 9.9/10 9.9/10
(10 reviews)

Hello! There is much simpler solution than a macro for your problem.

Even06

1 day

10-30-2007 18:07 EDT

9.6667/10
(6 reviews)

Hello, we can make a function in VBA(VisualBasic for Applications) for make the change. We can start right now if you give us the ok. Regards, Pablo

bigdragonfly

2 days

10-30-2007 20:21 EDT

9.5/10 9.5/10 9.5/10 9.5/10 9.5/10 9.5/10 9.5/10 9.5/10 9.5/10 9.5/10
(2 reviews)

hi, I can do it

shortwire

1 day

10-30-2007 21:05 EDT

10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10
(1 reviews)

Please refer PMB

hanke

2 days

10-30-2007 19:47 EDT

(No Feedback Yet)

hi, please check PM

KRAMRAO

2 days

10-30-2007 23:05 EDT

(No Feedback Yet)

pls refer my bid

stefen054

1 day

10-31-2007 00:39 EDT

(No Feedback Yet)

Simple macro would do this

Bid on this Project

WHAT IS FREELANCER.COM?

Freelancer.com is a global outsourcing solution and freelance jobs website. Here you can find freelance coders, writers, programmers, designers, marketers and more. You can also outsource projects and save a lot of money in the process. Getting the best web design, professional programming, custom writing or affordable marketing has never been easier!

We have thousands of satisfied clients from every corner of the world. Would you like to outsource your next project? Would you like to find freelance jobs and make money online? Just sign up to get started! Outsourcing jobs is the process of hiring an outside company or individual to complete your projects. We have created a safe environment for both service buyers and service providers via our secure payment system. You outsource the project and don't release any money until you're satisfied! Try outsourcing for free today! Don't forget to bookmark our homepage for your next project or job.