software

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.)

=quot;'quot;amp;A1

should work

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

quot;uncreativequot; gt; wrote in message
...
gt; Hello,
gt;
gt; Does anyone know of a method to insert leading apostrophes for a range of
gt; cells? (The concatenate function doesn't appear to work for this.)
You can make concatenate() work for you as follows:

if A1 contains data then =CHAR(39) amp; A1 will insert the leading single quote.
--
Gary's Studentquot;uncreativequot; wrote:

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

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

quot;Gary''s Studentquot; wrote:

gt; You can make concatenate() work for you as follows:
gt;
gt; if A1 contains data then =CHAR(39) amp; A1 will insert the leading single quote.
gt; --
gt; Gary's Student
gt;
gt;
gt; quot;uncreativequot; wrote:
gt;
gt; gt; Hello,
gt; gt;
gt; gt; Does anyone know of a method to insert leading apostrophes for a range of
gt; gt; cells? (The concatenate function doesn't appear to work for this.)