By Laura

- Excel – AVERAGEIF function, calculating average with conditions
- AVERAGEIFS function, calculating average with multiple conditions
- Excel - PRODUCT function for multiplying
- Excel – Examples and guidance for VALUE function- a function for converting string to number

When manipulating strings, it is a must to mention to Left function – a function to cut string from the left, Right Function – a function to cut string from the right, Mid function - a function to cut string from the middle, ect. We will guide you how to use LEFT with specific examples.

__Excel - LEFT function, for cutting left string__*Syntax: = LEFT (text, n)***In which:**** - text: **String.

**- n: **Number of characters that need to be cut from the string. (Without this parameter, Excel will set default value as 1).**Function:** Cut n characters in the text string from the left side of the string.**Example 1:**

- Cut three characters from "Computer" from the right.

- The formula would be: **LEFT **("Computer", 3) = Com

- If there is no parameter, you have to type in cell B3 = LEFT (C3), the results is shown as below: In the cell C16, the result will be C.

**Example 2:** I have the following tables:

- The requirement is to cut the first 3 letters of the commidity to set as code commidity.

- Apply the LEFT in this case to perform cutting string. The string formula is: = LEFT (C3, 3) and the result is shown as below.

We have introduced to you the syntax and usage of the Left function to cut string from the left. Excel also offers lots of helpful tools for you to manipulate on spreadsheets effectively .

- Related Articles:
- Excel - How to using the SUM function
- Excel – MAXA function, returning largest value
- Excel – FREQUENCY function, counting frequently-appeared values
- Excel – LARGE function, returning largest value number k
- Excel - How to use the ConcateNate function to connect character strings in Excel
- Excel - Connect strings having quotation marks, the CONCATENATE function

Related software

Excel Power Expander is a collection of useful and reliable utilities which are designed to extend the functionality of MS Excel. It provides 125 formulas and 87 new utilities.

- LockXLS - Protect Excel documents
- Asap Utilities - Support utilities in Excel
- Geometer`s Sketchpad for Mac - Drawing function graphs and implementing some calculations

Excel – Examples and guidance for VALUE function- a function for converting string to number

To convert a string to a number, Excel supports you a function - VALUE function. Normally, you do not need to use Value function since Excel will

Excel – AVEDEV function, calculating absolute deviation average

In the analysis and data processing, you have to calculate the absolute deviation average of given variables. AVEDEV function will help you solve

AVERAGEIFS function, calculating average with multiple conditions

You have to calculate average score of subjects or numbers with given conditions. The consideration of conditions will be time-consuming without

Excel – AVERAGEIF function, calculating average with conditions

AVERAGEIF is used for calculating average of cells with given conditions. The function for calculating average with conditions is more sufficient and

Excel - PRODUCT function for multiplying

To multiply numbers, Excel supports you with a very convenient function-PRODUCT. This function helps you multiply numbers quickly and