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

Found few bugs in my daily routine of work in excel for MAC 0
Problem with SET & REF function 0
Export BPMN Visio Chart to Excel 0
VBA - exporting serial letters to single documents 0
Found few bugs in my daily routine of work in excel for MAC 0
Modern equivalent of Autotext in Word? 0
Setting column width in a table with a macro is not working 0
How to bulk add section breaks after a particular combination of letters/numbers 0

Top