I'd like to know how to concatenate when the value of the B cells are
non-zero as follows:

="The result is as follows...Detail: " & A1 & B1 & A2 & B2 & A3 & B3
&...Ax & Bx & "Total=" & Text(Sum(B1:Bx),"$#,##0.00"

If a B cell value is zero, then don't concatenate with the corresponding
A cell.

The result should be something like this:
Result is as follows...Detail: Hotel=$150.00, Gasoline=$75.00,
Total=$225.00

Thanks,
Bernie

*** Sent via Developersdex http://www.developersdex.com ***