View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default 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