=RIGHT(Destination Cell, Number of Characters) This tells Excel: Starting on the left of this specified cell, copy to this many characters. =LEFT(Destination Cell, Number of Characters) In cell E2, you will enter the following formula: So in cell C2, you will enter the following formula:įor the client ID, we will use the RIGHT function. We know the code is 6 digits, so we have the number of characters. Your job is to separate the order number and client ID into Columns C and E, respectively.įor the order number, we will use the LEFT function. The 6-digit number is the order number and the 4 digit is the client ID. In this example, Column A contains a 6-digit number hyphenated with a 4-digit number. Since then, we’ve had several follow up requests on the LEFT and RIGHT.įor today’s demonstration, we will be using the following spreadsheet: At the time, one of our customers asked for a demo on the MID function. The RIGHT function performs the same except starting at the rightmost point.īoth functions are related to the MID function, which we covered back in September. In the LEFT function, you can pull a set number of characters out of a cell into another cell starting at the leftmost point. This demonstration covers how to use the LEFT and Right Functions in Excel.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |