Register now or log in to join your professional community.
"=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.
Please participate and answer this question.
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.
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
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
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.