="'"&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.)