add apostrophe to text in cell

  • Thread starter Thread starter WJS
  • Start date Start date
W

WJS

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 cells>Copy>Rightclick>PasteSpecial>Values>OK...to convert back to
values..Save this sheet as a separate workbook.

If this post helps click Yes
 
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
 
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
 
Back
Top