Copying text from multiple cells.
in [Functions]
|
Prev: How to insert maths symbols into an excell function?
Next: Fixing a formula to read a general format?
From: Spearhead on 16 May 2010 16:45 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???
From: Gord Dibben on 16 May 2010 17:05
=A1&","&B1&","&C1 Gord Dibben MS Excel MVP On Sun, 16 May 2010 13:45:01 -0700, Spearhead <Spearhead(a)discussions.microsoft.com> 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??? |