Create a 'text' string based on whether values appear in other
Ben wrote...
....
May I quickly ask, how can I insert a 'carriage return' to make the
next discount go on the next line??
....
="... one discount"&CHAR(10)&"another discount ..."
but you need to set the cell to wrap, and you may have to increase
column widths.
|