Thread: Adding an * to a renge of cells
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default 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
Reply With QuoteReply With Quote