How doo I add letters or numbers to a whole column of part #s

C

chromey

How doo I add letters or numbers to a whole column of part #s ? I have
microsoft excel 2003
 
F

FSt1

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Showing Letters For Column Headers Rather Thann Numbers ? 1
Columns are numbers instead of letters 4
Columns now numbers rather than letters how do i get letters back 2
Letter and space count in cell 1
Excel 2007... fix column headings from numbers back to letters 4
Column header format 5
2007, excel column hdings are now numbered - how do I get letters 1
need to average based on criteria 2

Top