Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

What do this function "=LEFT(F4,5)" do in excel?

"=LEFT(F4,5)" when you perform this function will take the5 figures from the cell you will select in the range. You may increase or decrease the numbers.

user-image
Question added by Zafar Iqbal , Teacher (Pak Studies) Subject Specialist , Home Tutor
Date Posted: 2013/09/20
Zafar Iqbal
by Zafar Iqbal , Teacher (Pak Studies) Subject Specialist , Home Tutor

Please participate and answer this question.

Ahmed Maher allam
by Ahmed Maher allam , Senior IT Consultant , CBK - G&D - AXIS-olutions

the functions LEFT or RIGHT are used to return an amount of letters from the referenced cell that contains a string value.

if the cell F4 contains a string value "zafar Iqbal" and u applied ur function above the output will be "zafar" only.

Shakeel Ahmed
by Shakeel Ahmed , Corporate Trainer in Data Analystics and Visualisation , NASASOFT COMPUTERS

The Excel Text function is use to Extract specified number of characters from beginning of a string.

 

=Left(F4,5), will extract 5 Character from the beginning of a string which is store in the cell F4.

 

For Example:

In Excel sheet if Cell reference F4 contains a text "Hello Dubai", then the above function would Extract Hello (which is 5 characters from the beginning of that string) from this cell and place it in the cell where you have entered this function

Raja Mohamed Iqbal
by Raja Mohamed Iqbal , Accountant , The Heart of Europe - Kleindienst Group

Your formula will work like this

1.Fetches 5 characters starting LEFTSIDE of the contents in CELL F4

2. Stores it as text, even if you fetch NUMBERS, once you remove the formula

3. Fetched data includes SPACES as well

Syed Bilal Irshaad
by Syed Bilal Irshaad , Accountant , Juma Al-Majid Group

This function will extract first5 characters from the left side, from the value/string in cell F4.

 

This function exracts "n" number of character(digits, alphabets etc) from a string.

In the formula above i.e. =LEFT(F4,5)

F4 represents a string. String can be any value, i.e. text, numbers, special characters etc. you can either type the value while entering the formula or you can use a cell reference. if

5 represents the number of characters you want to extract from the string.