How to combine text from 2 cells into 1 cell in Ms Excel
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.
Posts
How to add line break in Ms Excel cell using formula
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?
How to open 2 Excel files and separately show them in 2 computer monitors.
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:
How to auto run a VBA macro whenever Ms Excel or Ms Project starts
This is how you can set the VB macro to auto run whenever Ms Excel or Ms Project starts.
Autofill empty cells with content from the first cell above the empty cells in Microsoft Excel
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