You can find specific text, numbers, and formulas in current worksheet and all worksheet of a workbook by using the key “CTRL + F”. You can replac...
In this article we will learn if cell contains word then how to assign value in Microsoft Excel 2010. Let's consider we have a situation where we n...
We use symbols to custom format numbers in Microsoft Excel. We can use formats like “#”, “0” (zero), Comma “,”, “k”, etc. 0 (zero):...
To use a picture to watch cell values in other sheets, we use the Camera tool in Microsoft Excel 2010. Camera Tool - Camera tool creates a mirror i...
To select specific cells that only contain text, we can use the Go-To option or Conditional Formatting in Excel. Let’s take an example and understa...
In this article we will learn counting how many times specific character appears in excel 2010. To return the count of specific character in a cel...
To separate the first and the last name from a cell in Microsoft Excel, you can use a combination of a few functions. Use the “Left” function comb...
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.
