| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
| How do I find and replace a number with a minus sign in front? | Excel Discussion (Misc queries) | |||
| Part Number Lookup | Excel Worksheet Functions | |||
| How do I add a zero in front of a number in general format? | Excel Discussion (Misc queries) | |||
| duplicate number | Excel Discussion (Misc queries) | |||
Linear Mode
