iNSERT LEADING APOSTROPHE

U

uncreative

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

Bob Phillips

="'"&A1

should work

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)
 
G

Gary''s Student

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

if A1 contains data then =CHAR(39) & A1 will insert the leading single quote.
 
Top