Käynnissä

Macro for use in Excel 2000

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'.

Taidot: tiedonsyöttö, Visual Basic

Näytä lisää: we excel, how to use data entry in excel, excel to web, excel macro how to, excel &, data entry macro, excel 2000 database web data entry, excel 2000 data entry macro, excel download database excel 2000 vba, uses for excel, new excel, excel uses, web king, Use, macro, macro excel, macro + excel, king of the, fifty one fifty, excel\ , excel, excel function, excel c#, excel database visual basic, visual basic database excel database

Tietoa työnantajasta:
( 34 arvostelua ) Harrow, United Kingdom

Projektin tunnus: #190984

Myönnetty käyttäjälle:

hiratariq

Please see PM

30 $ USD 1 päivässä
(9 arvostelua)
4.1

10 freelanceria on tarjonnut keskimäärin 39 $ tähän työhön

MAnkita

Hello,Please check your [url removed, login to view] you.

50 $ USD 1 päivässä
(87 arvostelua)
6.1
shortwire

Please refer PMB

30 $ USD 1 päivässä
(23 arvostelua)
4.1
skilledsir

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

30 $ USD 0 päivässä
(5 arvostelua)
3.1
Even06

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

35 $ USD 1 päivässä
(1 arvostelu)
0.0
dren

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

30 $ USD 0 päivässä
(0 arvostelua)
0.0
hanke

hi, please check PM

50 $ USD 2 päivässä
(0 arvostelua)
0.0
bigdragonfly

hi, I can do it

50 $ USD 2 päivässä
(0 arvostelua)
0.0
KRAMRAO

pls refer my bid

45 $ USD 2 päivässä
(0 arvostelua)
0.0
stefen054

Simple macro would do this

40 $ USD 1 päivässä
(0 arvostelua)
0.0