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.

If you mean add apostrophe to all cells with data....If you have data in
Sheet1; in Sheet2 cell A1 enter the below formula

=IF(Sheet1!A1<"","'" & Sheet1!A1,"")

Now copy this formula down and across as required. Once done Copy the range
of cellsCopyRightclickPasteSpecialValuesOK...to convert back to
values..Save this sheet as a separate workbook.

If this post helps click Yes
---------------
Jacob Skaria


"WJS" wrote:

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.

Hi,
use a helper column, let' say your data starts in cell A1 in B1 you enter

="'"&A1

copy formula down

if this helps please click yes, thanks

"WJS" wrote:

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.

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.