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 ... 16 May 2010 17:56 How to insert maths symbols into an excell function? ... 16 May 2010 16:51 evaluate No, I don't see how that could ever be True. -- Rick (MVP - Excel) "afdmello" wrote in message news:eXrWFES9KHA.3840(a)TK2MSFTNGP02.phx.gbl... I saw a worksheet for training programs in which this formula is written =IF(C5<1/1/1902,0,IF(C6>EDATE(C6,12),0,1)) can the function... 16 May 2010 16:51 Tables in excel- bringing down formulas for new records. I am trying to put together a table and want to have an auto number that counts the recods and puts the next number in for a new record. Need a good method to do this and to have it automatically carried down when a new record is created. I also have a formula that calculates interest on a principle amount. ... 18 May 2010 20:21 evaluate I saw a worksheet for training programs in which this formula is written =IF(C5<1/1/1902,0,IF(C6>EDATE(C6,12),0,1)) can the function C6>EDATE(C6,12) can ever be true as the logic is refering to the same cell afd ... 16 May 2010 14:39 EXCELL I cant open an excell file - it says read only or encrypted ... 16 May 2010 12:27 FORMULA??? I AM TRYING TO ORGANIZE SOME DATA VERTICALLY BUT IS ALL HORIZONTALLY... FOR EXAMPLE: THIS IS WHAT IT LOOKS LIKE A B C 1 TIM MAY 3 12 2 MATT APRIL 3 15 3 WAYNE DEC 16 24 IS THERE A FUNCTION WHERE U CAN CHANGE IT TO ... 16 May 2010 12:27 Excel xscx Bet wrote: Excel 2007 Error message when trying to record Macro 13-May-08 I recorded a macro. I decided that I did not want the macro to perform the final function that I had recorded. I deleted the last couple of lines of code in the macro. Ever since then, when I try to record a new macro to b... 16 May 2010 03:48 How do I auto Expand a cell for printing only? I would like to retain the format of the row hieght for the electronic document. ... 16 May 2010 08:06 how do you have the headings scroll down the page as you move dow How do you have the column headings scroll with you as you work downward on a page ?? Help . . . Bless you for information - much needed ! Thanks ... 15 May 2010 23:32