G
Guest
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.
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.