We are making a spreadsheet that we are going to give to another
department to fill out. They will fill in an amount and an
explanation. We need this data to link into one cell in paragraph form
if possible. For example they will enter in column D the explanation,
and in E the amount like below:

Because I said so $10
Who is asking $16

I want it to show in the other paragraph cell:

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

The row numbers are 8-52 and the difficult thing is that some rows will
be skipped meaning they might enter data in row 8 and 9, and then skip
to 33 and 34 then skip again to 45.

I have tried using & and” “ in formulas to combine and space things
out, but two problems, no $ show up with the numbers in the paragraph
and with the skips we end up with several spaces where it looks like
this

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

Can anyone help here


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