| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding an * to a renge of cells
I AM COMBINING 4 CELLS TOGETHER IN ONE CELL TO CREATE A BAR CODE. I NEED TO
ADD AN * BEFORE THE FIRST AND LAST NUMBER. ANY SUGGESTIONS?? EX. OF FORMULA AS IS NOW =(A1&B1&C1&D1) RESULT CELL A3 HA128373VENDORXL1PC19000 - ALL IN BARCODE I NEED THE BAR CODE TO READ *HA128373VENDORXL1PC19000* - ALL IN BARCODE |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Adding an * to a renge of cells
Before the first character and after the last?
="*"&A1&B1&C1&D1&"*" BAKERSMAN wrote: I AM COMBINING 4 CELLS TOGETHER IN ONE CELL TO CREATE A BAR CODE. I NEED TO ADD AN * BEFORE THE FIRST AND LAST NUMBER. ANY SUGGESTIONS?? EX. OF FORMULA AS IS NOW =(A1&B1&C1&D1) RESULT CELL A3 HA128373VENDORXL1PC19000 - ALL IN BARCODE I NEED THE BAR CODE TO READ *HA128373VENDORXL1PC19000* - ALL IN BARCODE -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Adding an * to a renge of cells
"Dave Peterson" wrote: Before the first character and after the last? ="*"&A1&B1&C1&D1&"*" BAKERSMAN wrote: I AM COMBINING 4 CELLS TOGETHER IN ONE CELL TO CREATE A BAR CODE. I NEED TO ADD AN * BEFORE THE FIRST AND LAST NUMBER. ANY SUGGESTIONS?? EX. OF FORMULA AS IS NOW =(A1&B1&C1&D1) RESULT CELL A3 HA128373VENDORXL1PC19000 - ALL IN BARCODE I NEED THE BAR CODE TO READ *HA128373VENDORXL1PC19000* - ALL IN BARCODE -- Dave Peterson thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ADDING CELLS | Excel Discussion (Misc queries) | |||
| I need help adding cells together? | Excel Worksheet Functions | |||
| Adding Cells | Excel Worksheet Functions | |||
| Adding colour to a range of cells based on one of the cells v... | Excel Discussion (Misc queries) | |||
| Renge filtering | Excel Worksheet Functions | |||
Linear Mode
