Thread: Adding an * to a renge of cells
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
BAKERSMAN BAKERSMAN is offline
external usenet poster
  
Posts: 36
Default 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


Reply With QuoteReply With Quote