Almost a Technocrat in Draft

This is how you can combine text contents from 2 cells into 1 cell using formula. You can even insert your custom text in between, before or after the combined text. To combine text contents from 2 cell into 1 cell, use the "&" to join them together: A1&B1 If you want to insert a space in between the 2 combined text: A1&" "&B1 If you want to insert a hyphen in between them: A1&" - "&B1 If you want to add your custom text before the combined text: "custom text "&A1&B1 If you want to add your custom text after the combined text: A1&B1&"custom text" You can also combine the text together using "CONCATENATE" function: CONCATENATE(A1,A2) CONCATENATE(A1," ",A2) via ( http://office.microsoft.com/en-001/excel-help/use-formulas-to-edit-correct-and-proofread-text-RZ006183133.aspx?section=12 )

This is how you can add a line break into Ms Excel cell using formula. Using keyboard while typing into the cell, to insert a line break just hit "at+enter". But what about using formula? To insert a line break into Ms Excel cell using formula, use this: CHAR(10) Example: ="this is the first line"&CHAR(10)&"this is the 2nd line" via( http://excel-formulas.blogspot.com/2009/03/line-break-in-cell-using-formula.html )

By default if you try double clicking and open 2 Excel files, they will open up and stack into 1 instance of Excel program. What if you are cross referencing 2 Excel files using 2 monitors? You definitely want them to show each in one monitor (if you have 2 computer monitors). This is how simple you can workaround it: Directly run Excel program from your start menu 2 times so that you have two Excel running at the same time. Notice that they are in separate window instead of stacking on each other. Drag each of your Excel files into each of the running Excel program. Now you have 2 windows of Excel showing each of your Excel files.  Just put each of your Excel window to each of your 2 computer monitors. Now you can cross reference your 2 Excel files using 2 computer monitors.

This is how you can set the VB macro to auto run whenever Ms Excel or Ms Project starts. To do this, rename your macro name to "Auto_Open". Yes! it's as simple as that. References, Sources and Credits: Running a macro when Excel starts

Non Macro Solution Select the first cell that have the content that need to be paste to the empty cells. Scroll down to the last empty cells below the first cell that needed to be fill. Hold shift and select the last cell. Ctrl + D Macro Solution Sub fill_cells()     Selection.SpecialCells(xlCellTypeBlanks).Select     Selection.FormulaR1C1 = "=R[-1]C"     Range(Cells(1, 1), Selection.SpecialCells(xlCellTypeLastCell)).Select     Selection.Copy     Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False End Sub References: My Excel Pages -- David McRitchie (Fill The Empty Cells)