Written by Allen Wyatt (last updated October 7, 2023)
This tip applies to Excel 97, 2000, 2002, and 2003
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.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2488) applies to Microsoft Excel 97, 2000, 2002, and 2003. You can find a version of this tip for the ribbon interface of Excel (Excel 2007 and later) here: Returning the Left-most Characters.
Create Custom Apps with VBA! Discover how to extend the capabilities of Office 2013 (Word, Excel, PowerPoint, Outlook, and Access) with VBA programming, using it for writing macros, automating Office applications, and creating custom applications. Check out Mastering VBA for Office 2013 today!
Excel includes a handy function that allows you to repeat characters or strings of characters. How you use the REPT ...
Discover MoreChanging the capitalization of text is, believe it or not, a common task in Excel. Common or not, it can be frustrating ...
Discover MoreThe PROPER worksheet function is used to change the case of text so that the first letter of each word is capitalized. If ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
There are currently no comments for this tip. (Be the first to leave your comment—just use the simple form above!)
Got a version of Excel that uses the menu interface (Excel 97, Excel 2000, Excel 2002, or Excel 2003)? This site is for you! If you use a later version of Excel, visit our ExcelTips site focusing on the ribbon interface.
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2025 Sharon Parq Associates, Inc.
Comments