Thanks Tom! I did that and it didn't show the value. It
showed the formula. Did I do something wrong?

Carla


-----Original Message-----
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


.