Hi,

You can download and install ASAP utilities (http://www.asap-utilities.com/)
and then select the range then go to ASAP Utilities Fill Insert before
current values. Enter ' in the before box. Click on OK. Now copy this
columns and paste special values in another range

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"WJS" wrote in message
...
Program in company data base requires an apostrophe in the text cell. My
program is text cell but does not have aposrophe. How do I put an
apostrophe
in my file to match companies short of manually adding it. Excel 2007 and
4000 rows and 5 columns.