Devam Ediyor

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

Beceriler: Veri Girişi, Visual Basic

Daha fazlasını görün: we excel, use data entry excel, data entry macro, uses excel, new excel, excel uses, web king, use, macro, macro excel, king, excel function, excel database visual basic, excel project use database, project macro, point excel, vertical columns, source function excel, macro excel database, excel macro database download, letter use database, macro data entry, excel letter database, excel macro download web, final project excel database

İşveren Hakkında:
( 34 değerlendirme ) Harrow, United Kingdom

Proje NO: #190984

Seçilen:

hiratariq

Please see PM

1 gün içinde 30$ USD
(9 Değerlendirme)
4.1

10 freelancer bu iş için ortalamada 39$ teklif veriyor

MAnkita

Hello,Please check your PMB.Thank you.

1 gün içinde 50$ USD
(87 Değerlendirme)
6.1
shortwire

Please refer PMB

1 gün içinde 30$ USD
(23 Değerlendirme)
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

in 0 gün içinde30$ USD
(5 Değerlendirme)
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

1 gün içinde 35$ USD
(1 Değerlendirme)
0.0
dren

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

in 0 gün içinde30$ USD
(0 Değerlendirme)
0.0
hanke

hi, please check PM

in 2 gün içinde50$ USD
(0 Değerlendirme)
0.0
bigdragonfly

hi, I can do it

in 2 gün içinde50$ USD
(0 Değerlendirme)
0.0
KRAMRAO

pls refer my bid

in 2 gün içinde45$ USD
(0 Değerlendirme)
0.0
stefen054

Simple macro would do this

1 gün içinde 40$ USD
(0 Değerlendirme)
0.0