how to add a charater in front of part number
 

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

how to add a charater in front of part number
 

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?

how to add a charater in front of part number
 

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?

how to add a charater in front of part number
 

Did you try search/replace

310
with
"310

??

Beege


"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?

how to add a charater in front of part number
 

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?