Unless I've misunderstood you, this is very straightforward. You can use the ampersand operator to append the different cells into one long string.

Assuming we're using row 1 then cell G1 will contain the following formula:
=b1 & ", " & a1 & " (" & c1 & ")"

Edit: Corrected row and column references.


Edited by AndrewT (23/08/2006 18:52)