 # Tag Archives: Formulas

## Excel Functions and Formulas, Adding (Concatenating) Text

Adding (Concatenating) text in cells can be done using the “&” symbol. In the example below cell D2 adds (concatenates) the strings in cells A2, B2 and C2: Result: By modifying the values in the cells A2, B2 or C2 the value in D2 is automatically updated:

## Excel Functions and Formulas, LEN()

The LEN() function returns the number of characters in a text string. Syntax: =LEN(Text String) Text String: The text string to return the number of characters of. – Example: Lets say we want to receive the number of characters of the text string in cell

## Excel Functions and Formulas Get Substring, MID(), LEFT(), RIGHT()

In this article I will explain the functions MID(), LEFT(), RIGHT(). The main purpose of these functions is to return a certain number of characters (substring) from a text. You can download the workbook related to this article here. Jump To: Syntax LEFT RIGHT MID

## Excel Formulas and Function, Finding Text Within Another Text, Find()

The function FIND() searches for a specific text expression inside another text and returns the first index which the text was found. You can download the workbook related to this article here. Jump To: Syntax Example 1 Example 2 Syntax: =FIND(Text_to_Find, Text_to_Search_in, Starting_Index) Text_to_Find: The

## Excel INDEX() Function

In this article I will explain the INDEX() function in Excel. Basically this function receives a range of cells, a row index and a column index as input. It returns the the value or reference of the cell at the specified row and column index.

## Excel Change Formula Calculation to Manual

In this article I will explain how you can prevent Excel from automatically updating formulas. This is specially useful when working with large workbooks with a large amount of formulas. You can force excel to update the formulas only when specified. – Changing Formula Calculation to Manual:

## Excel COUNT() Function

In this article I will explain the count function. The COUNT() function returns the number of cells in a range which have numeric values in them. You can download the workbook for this article here. Jump To: Syntex Example 1, Get Row Count Example 2,

## Excel Functions and Formulas, TEXT()

The TEXT() function converts a number value to a text string, with the format specified Jump To: Syntax Example 1, Converting Numeric Value to a Text String Using Currency Formatting Example 2, Adding Converted Value to a Text String Example 3, Converting Numeric Value to

## Excel Functions and Formulas, IF()

In this article I will explain the IF() function. The IF() function receives 3 input parameters. The first input parameter is a logical test. The logical test will either equate to True or False. If the logical test equates to TRUE then the second parameter