[ad_1] How to Fix Unknown Error 0x8004060C in Microsoft Outlook The article intends to help users know what the error unknown 0x8004060C is in Microsoft Outlook and how to fix it using simple methods. The methods described here are simple and correct until date. It is still recommended that users follow the instructions accurately to…
[ad_1] SEARCH Function and FIND Function in Microsoft Excel There are two very similar functions in Excel to look for data inside of cells matching parameters that you dictate: SEARCH and FIND. There are so similar, in fact, that one wonders why have two separate functions that perform virtually the identical results and are identical…
PROPER is an Excel formula that is used to capitalize the first letter in a text string and any other letters in text that follow any character other than a letter. It basically converts all other letters to lowercase letters. This formula is used when we have data to be curated. Formula: =PROPER (text) Below…
LEFT is an excel formula which is used to extract the LEFT most part of the data. This formula can be used when we need specific characters from a text in a cell. Formula: =LEFT (text, [num_chars]) Below is an example: In the above example, the LEFT formula is being used to retrieve 5 LEFT most…
RIGHT is an excel formula which is used to extract the right most part of the data. This formula can be used when we need specific characters from a text in a cell. Formula: =RIGHT (text, [num_chars]) Below is an example: In the above example, the RIGHT formula is being used to retrieve 4 right most…
TRIM is an excel formula that is used to remove extra spaces before or after a text in a cell. TRIM can be used when cleaning up text that has come from other applications or environments. Formula: =TRIM(text) Below is an example: In the above example, the TRIM formula is being used to remove the spaces before…
LEN is an excel formula that is used to count the character length in a cell. It can be used to count numbers/texts in given cells. Formula: =LEN(text) Below is an example: In the example, the LEN formula is being used to count the number of characters present in the cell. As you can see we have…
Navigate Worksheets [Arrow Keys] Navigate by one cell at a time in any direction [Page Down]/[Page Up] Move one screen down/ up [Alt]+[Page Down]/[Page Up] Move one screen right/ left [Tab]/[Shift]+[Tab] Move one cell to the right/ to the left in a worksheet [Ctrl]+[Arrow Keys] Move to the edge of next data region (cells…
COUNTA is an excel formula that is used to count, the number of cells in a range that have values or data in a given/selected range. It can be used to count numbers/texts in columns, rows or in multiple selected cells. Formula: =COUNTA(Value1,Value2,…) Below are examples of the simple usage of the COUNTA formula. In Formula Bar, you will…
COUNT is an excel formula that is used, as suggestive it can be, to count, the number of cells in a range that have numbers in a given/selected range. It can be used to count numbers in columns, rows or in multiple selected cells. Formula: =COUNT(Value1,Value2,…) Below are examples of the simple usage of the COUNT formula.…