iNSERT LEADING APOSTROPHE
 

Hello,

Does anyone know of a method to insert leading apostrophes for a range of
cells? (The concatenate function doesn't appear to work for this.)

iNSERT LEADING APOSTROPHE
 

="'"&A1

should work

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"uncreative" wrote in message
...
Hello,

Does anyone know of a method to insert leading apostrophes for a range of
cells? (The concatenate function doesn't appear to work for this.)

iNSERT LEADING APOSTROPHE
 

You can make concatenate() work for you as follows:

if A1 contains data then =CHAR(39) & A1 will insert the leading single quote.
--
Gary's Student


"uncreative" wrote:

Hello,

Does anyone know of a method to insert leading apostrophes for a range of
cells? (The concatenate function doesn't appear to work for this.)

iNSERT LEADING APOSTROPHE
 

Great! Thanks, guys; both options worked for me.

"Gary''s Student" wrote:

You can make concatenate() work for you as follows:

if A1 contains data then =CHAR(39) & A1 will insert the leading single quote.
--
Gary's Student


"uncreative" wrote:

Hello,

Does anyone know of a method to insert leading apostrophes for a range of
cells? (The concatenate function doesn't appear to work for this.)