Paste Special?

Giganews Newsgroups
Subject: Paste Special?
Posted by:  techjohn… (techjohn…
Date: Wed, 25 Mar 2009

I have a column of part numbers that I'd like to copy and paste into
another column using a barcode font.  The barcode scanner requires
that each part number has a * preceding and succeeding the number.
Can somebody help me where I should be looking in excel to make this
happen, without having to have the user type in a * before and after
the part number?