Macro for use in Excel 2000

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

Status:	Closed (Selected Service Provider)
Selected Providers:	selected service provider hiratariq
Budget:	$30-100
Created:	10/30/2007 at 17:57 EDT
Bidding Ends:	11/09/2007 at 17:57 EST
Project Creator:	AlanB   Buyer Rating: (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'.
Job Type:	Data Entry Visual Basic
Database:	Other
Operating system:	MS Windows
Bid count:	10
Average bid:	$ 39