RIGHTA12 This first part is telling Excel to start at the right hand side of our date number and then only take the first two numbers from that right hand side. I know how to use the left and right functions separately but cant seem to get them working together. In this video we look at how to use the RIGHT and LEFT functions to extract one or more characters from the beginning or end of a string.
I have an Address column and need to display discard in another column Status when the address is a PO Box and 0 in the status column when it is a street address.
You can use the following RIGHT Formula in Excel. For the Left and Right Formulas text is the string you want to break apart and num_chars is the number of characters you want the left or right of. To extract these figures we will use the function LEFT. RIGHTA12 This first part is telling Excel to start at the right hand side of our date number and then only take the first two numbers from that right hand side.