Sorry, then just use ="'"&A1

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"chiuinggum" wrote in message
...
I want to add an apostrophe in front of a part number

"Bob Phillips" wrote:

use another column with a formula of

="3100"&A1

copy it down, the copy and Paste values and remove the old column A.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"chiuinggum" wrote in message
...
I have a list of part number and the part number starts with 310xxxx.
How can I add " to make it "310xxxx?