View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ben Ben is offline
external usenet poster
 
Posts: 509
Default Formatting Cells?

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.