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.

Help!!
 

Change the formula in A3 to:

="*"&A1&A2&A3&A4&"*"

HTH,
Elkar


"BAKERSMAN" wrote:

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.

Help!!
 

maybe also like this
="*"&A1&A2&A3&text(a4,"m/dd/yyyy")&"*"
regards,
driller
--
*****
birds of the same feather flock together..



"Elkar" wrote:

Change the formula in A3 to:

="*"&A1&A2&A3&A4&"*"

HTH,
Elkar


"BAKERSMAN" wrote:

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.