Copying text from multiple cells.
 

I have a seven spreadsheets (by day of the week and one consolidated sheet)
that keeps track of how many hours a student misses in a week. Calulating the
time on a consolidation sheet is no problem. I am trying to combine any
Text (reason for absents) into one cell for that student on the consolidated
sheet that would show one reason after the other with a comma seperation.

can anyone help???

Copying text from multiple cells.
 

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


Gord Dibben MS Excel MVP


On Sun, 16 May 2010 13:45:01 -0700, Spearhead
wrote:

I have a seven spreadsheets (by day of the week and one consolidated sheet)
that keeps track of how many hours a student misses in a week. Calulating the
time on a consolidation sheet is no problem. I am trying to combine any
Text (reason for absents) into one cell for that student on the consolidated
sheet that would show one reason after the other with a comma seperation.

can anyone help???