add apostrophe to text in cell
 

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.

add apostrophe to text in cell
 

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.

add apostrophe to text in cell
 

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.

add apostrophe to text in cell
 

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.