Looking up values in multiple cells

R

Richard

Hi,

I have a spreadsheet that shows open purchase order lines, the due date and
the quantity. Some part numbers have multiple receipt dates and quantities.
How can I get those multiple dates into one cell on another spreadsheet?


Thank you,
 
R

Roar

Hi Richard,
If the receipt dates are located in B2 and B3, the formula may be

=TEXT(B2,"dd.mmm.yy")&", "&TEXT(B3,"dd.mmm.yy")
 
Top