How do I display summary of different cells in one cell?

T

tomlee4now

Hi,

I am trying to summarize in one cell, all the different shoe sizes worn
through the week. my spreadsheet looks like this

Mon Tue Wed Thu Fri
Shoe size worn 5 6 4 8 9




Shoe Sizes Worn through week 5,6,4,8,9


I'd like to somehow display 5,6,4,8,9 in one cell. Is there an easy way
to do this without a huge nested IF thing?

Thank you in advance

-Tom
 
B

Bucky

I'd like to somehow display 5,6,4,8,9 in one cell. Is there an easy way
to do this without a huge nested IF thing?
Click to expand...

you can use string concatenation, for example:

=B2 & ", " & B3 & ", " & B4
 
Top