C
chiuinggum
I have a list of part number and the part number starts with 310xxxx.
How can I add " to make it "310xxxx?
How can I add " to make it "310xxxx?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Bob Phillips
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)
="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)
C
chiuinggum
I want to add an apostrophe in front of a part number
B
Beege
Did you try search/replace
310
with
"310
??
Beege
310
with
"310
??
Beege
B
Bob Phillips
Sorry, then just use ="'"&A1
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)