How to use LEFT Function In Excel

In this Excel Function Explained video series, I’ll explain how to use left function in excel. Excel Left function is mainly used to extract text in excel. But there is a huge diversity of uses of left function in excel. One thing to keep in mind that whatever this function does, it starts from the left of your strings (Text, symbol or number).

Some of the things you can do using left function in excel is to extract text from cell, tell excel to remove characters from left, extract text from a string directly from the function, extract numbers from string and many more. The opportunity is endless here. This is why we should learn to use left formula in excel. Another important aspect of this function is that you are allowed to use left function in excel vba also.

Without further ado let’s move forward and learn how to use left formula in excel.
The Function looks like this =LEFT (Text, Number of characters)
The Left function has two parameters or arguments.
1. Text: in this parameter, we need to either write the text or specify the cell from where we need to extract the text.
2. Number of Characters: Here we will specify how many characters we need to extract.
Now there are a few things you need to consider before using this function.
1. It considers space, decimal or any symbol as a character.
2. It always starts counting from the left.

This is how to use left in excel. Remember, using left function in excel you actually tell excel formula to extract text.

#Excel #Function #Left
Thanks for watching.
-------------------------------------------------------------------------------------------------------------
Support the channel with as low as $5
  / excel10tutorial  
-------------------------------------------------------------------------------------------------------------
Please subscribe to #excel10tutorial
https://goo.gl/uL8fqQ

Here goes the most recent video of the channel:
https://bit.ly/2UngIwS

Playlists:
Advance Excel Tutorial: https://goo.gl/ExYy7v
Excel Tutorial for Beginners: https://goo.gl/UDrDcA
Excel Case: https://goo.gl/xiP3tv
Combine Workbook & Worksheets: https://bit.ly/2Tpf7DB
All About Comments in Excel: https://bit.ly/excelcomments
Excel VBA Programming Course: http://bit.ly/excelvbacourse

Social media:
Facebook:   / excel10tutorial  
Twitter:   / excel10tutorial  
Blogger: https://excel10tutorial.blogspot.com
Tumblr:   / excel10tutorial  
Instagram:   / excel_10_tutorial  
Hubpages: https://hubpages.com/@excel10tutorial
Quora: https://bit.ly/3bxB8JG Become a member and enjoy exclusive perks while supporting the channel you love!
   / @excel10tutorial