| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How doo I add letters or numbers to a whole column of part #s
How doo I add letters or numbers to a whole column of part #s ? I have
microsoft excel 2003 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How doo I add letters or numbers to a whole column of part #s
hi
what letters or numbers. a formula would do it. lets say your column of Part #s are in column A. in a blank column enter =A2 & "your letters" or ="your numbers"& A2 copy the formula down as far as needed. when down simply copy the formula column and paste special value. then copy to column A. there could be a VB solution but that could get compicated depend on what your letters and numbers are. Regards FSt1 "chromey" wrote: How doo I add letters or numbers to a whole column of part #s ? I have microsoft excel 2003 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to sort part numbers, sometimes ignoring leading letters | Excel Discussion (Misc queries) | |||
| changing column letters to numbers , etc. | Excel Discussion (Misc queries) | |||
| Sorting a column from the last letter or 2 letters of a part numbe | Excel Discussion (Misc queries) | |||
| How can I change column numbers back to column letters? | Excel Worksheet Functions | |||
| row numbers & column letters | Excel Discussion (Misc queries) | |||
Linear Mode
