Thank you for the quick response. That worked, but not exactly the way I
want it to. After re-reading my post I didn't explain what I want very well.
Your formula is the end-result I want, that works perfect. I want more of
an automated process I guess since I am not the one that is going to be using
this. I would like the selections from the 3 drop-down lists to be placed
into the final cell as soon as they are selected. so if the first drop down
is in cell A1 and final cell is in A4, when the user selects 'Z' from the
drop-down then A4 will display 'Z,' at the same time. Your formula works
perfectly for this, but the only problem with that is each selection is going
to be displayed twice on each row. for example if drop-down lists 1-3
display 'a' 'b' 'c' then the final cell is going to display 'a,b,c' which I
can foresee being extremely confusing to the users, and kind of redundant
when printed. The only thing I can think of is to make the 3 drop-down lists
static, and create a macro that will input the selection into the final cell.
Do you have any ideas for that?



"Rick Rothstein (MVP - VB)" wrote:

If all the complaint cells do not have to be filled in, and if maintaining
an identity to which column(s) the complaint(s) came from, then this
modification of your formula will look neater...

=A1&IF(B1="","",IF(A1="","",", "))&B1&IF(C1="","",IF(AND(A1="",B1=""),"",",
"))&C1

If maintaining an identity to the complaint columns is required, then
perhaps this modification to your formula would be better for the OP to
use...

=IF(A1="","<?",A1)&", "&IF(B1="","<?",B1)&", "&IF(C1="","<?",C1)

Rick


"OssieMac" wrote in message
...
You have not said what sort of drop down list you have but I assume that
the
results of the selections are displayed in separate cells. If my
assumption
is correct, assuming that the 3 separate results are in cells A1, B1 and
C1
then you can concatenate the results into another cell.

=A1&", "&B1&", "&C1

The characters between the double quotes can be any characters you like to
use for the separation. In the above I have used a comma and a space.

Regards,

OssieMac


"Smatass" wrote:

I have 3 columns for 'complaint A', '..B', '..C'. Each of the cells in
those columns has the same drop-down list that contains 5 items. What I
want
to do is have the item from the drop down list moved/placed automatically
into a new cell, but I want the other two drop-down lists to have their
selections moved/placed into the same cell as the first drop-down list
without overwriting the first entry. The 3 entries in the single cell
would
be comma separated ideally. Does that make sense and is it possible?
Any
help is greatly appreciated. Thank you.