Returning a text value
 

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

Returning a text value
 

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


.

Returning a text value
 

Select the cell and the one below it (or if you copied the formula down, all
cells with the formula)

Do Edit=Replace
What: =
With: =

then click OK

This is often caused because either the cell with the formula is formatted
as text or one or more of the cells refered to by the formula are formatted
as text.

If the first thing, then format the cells as general (or try the method I
provided above).

--
regards,
Tom Ogilvy

"Carla Bradley" wrote in message
...
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


.