Assume the black s column is column B, so in J2 put in a formula like

=B2&C2&D2&E2&F2&G2&H2&I2

and drag fill down the column.

--
Regards,
Tom Ogilvy

"Carla Bradley" wrote in message
...
I have a client that needs some assistance and this is my
weak area. She has rows with a people's name. On the
columns she has black s, black m, black l, black xl, gray
s, gray m, gray l and gray xl. These are their shirt
preferences. And in those columns if someone was a gray
s, she actually types gray s in the gray s column under
the row for that person. She wants to create another
column called shirt preference that would list text in
any cell. For example if Bob wants a black xl shirt,
under his row it will say black xl in the black xl
column. So not every column has a value. Is there some
sort of if/then statement that would only retrieve the
value of the filled in cell and display the text? She's
XP.

Thanks a million!
Carla