Thread: Help!!
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
BAKERSMAN BAKERSMAN is offline
external usenet poster
 
Posts: 36
Default Help!!

I am combining 4 cells into one to have a barcode for a range of cells. I
need to add a * to the begining and the end of the formula.

EX.

A1 A2 A3
A4
BATCH MATERIAL MACHINE DATE
HA123 1234 4
6/26/2007


A3= HA123123446/26/2007 (IN BARCODE FORMAT)
A3=(A1&A2&A3&A4)

I NEED TO HAVE A * AT THE BEGINING AND END OF THE BARCODE.