| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding a prefix to all numbers in a column.
I have a spreadsheet containing part numbers and I want to add a text prefix
before each number to identify it by manufacturer. i.e. Part Number 12345 - I need to add a manufacturer identifier MANUFACTURERA-12345 to all part numbers in a spreadsheet. Can anyone help me to develop a macro to accomplish this or tell me how to combine a text field column with a numeric column? I would sincerely appreciate the help! Thank you. -- Randy |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
| Adding new numbers as I type without duplicates from Sheet1,ColumnA to Sheet2,ColumnA | Excel Worksheet Functions | |||
| match and count words | Excel Worksheet Functions | |||
| Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
| I cannot get a column of numbers to sum, why? | Excel Discussion (Misc queries) | |||
Threaded Mode
