|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 16th, 2010, 09:45 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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??? 
|
|
#2
May 16th, 2010, 10:05 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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???
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
