In B1:

="*" & A1 & "*"

Copy this down as needed.

HTH,
Paul

"Ben" wrote in message
...
Hello,
I need to know how to put an * before and after each value I have in a
column. For example, if Column A is 1 to 5, I will paste them in B, and
then
change them to barcode font. My scanner only reads barcodes that start
and
end in an * . It is easy to do it for a few by hand, but when there are
thousands, there has to be an easy way to do it. Thanks in advance.