If the last character is a forward slash it will return TRUE else FALSE. Formulas are the key to getting things done in Excel. 3 Finally drag the LEFT formula from cell B2 to B4 in order to get the results across your 3 records.
Ill be showing a few of the useful examples of it below.
Retrieve a specific number of characters from the right side of a string. Select a blank cell next to the numbers you want to add leading zero B2 for instance and enter this formula Add leading zero after decimal to fixed number length with formula TEXT A2000000 then drag autofill handle down to apply this formula to the cells you want. In this example the start date is in cell D17 and the end date is in E17. LEFT A3 6 displays the first six characters in cell A3.