Tips.Net > ExcelTips Home > Worksheet Functions > Text Functions > Returning the Left-most Characters
Returning the Left-most Characters
Summary: Need only the left=most characters from a text string? You can use the LEFT worksheet function to easily get just what you need. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, Excel 2003, and Excel 2007.)
Sometimes you may need to create a worksheet formula that examines the left-most characters in a different cell. To allow for this need, Excel provides the LEFT worksheet function. You use it by specifying the cell or value to use, along with the number of character to return. For instance, the following formula returns the three left-most characters in cell A7:
=LEFT(A7,3)
If the value in A7 is not text, then LEFT still treats it as if it is. Thus, if A7 contains 12345, then the above formula returns the text value 123.
Tip #2488 applies to Microsoft Excel versions: 97 2000 2002 2003 2007
Step Up and Take Control! Subscribers to ExcelTips know just how valuable a resource it is. ExcelTips Premium provides twice the number of exceptional, easy-to-understand tips every week in an ad-free newsletter, as well as substantial discounts on ExcelTips archives and e-books.
Check out ExcelTips Premium today!
An Amazing Resource!
Thousands of ExcelTips, available for immediate download. Have all the Microsoft Excel info you need, right at your fingertips. (more information...)
Helpful Links
Ask an Excel Question
Make a Comment
ExcelTips FAQ
ExcelTips Premium
Beauty Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Money Tips
Organizing Tips
Pest Tips
Pet Tips
Word2007 Tips
WordTips
Advertise on the
ExcelTips Site