| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
