Gary Brown Wrote:
Assuming your data in rows 8 to 52 is in columns A and B, put the
following formula in column c on rows 8 to 52:-

=IF(AND(ISBLANK(A8),ISBLANK(B8)),"",TEXT(B8,"$##") &" "&A8&"; ")

Then in the cell where you want the description:-

$10 Because I said so; $16 Who is asking;

enter the following:-

=TRIM(C8&C9&C10&C11&C12&C13&C14&C15&C16&C17&C18... ........&C52)


WOW I'm impressed, works like a dream!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
Thank you so much!!


--
caliskier
------------------------------------------------------------------------
caliskier's Profile: http://www.excelforum.com/member.php...o&userid=25887
View this thread: http://www.excelforum.com/showthread...hreadid=502534