Select Page

Excel Video 156 RIGHT

RIGHT works just like LEFT did in Excel Video 155 with similar parameters. First, you tell Excel where the text string is you want to extract characters from. Second, you tell Excel how many characters to extract. The trick with RIGHT is knowing how many characters to...

Excel Video 155 LEFT

You’ll be LEFT behind if you try to extract a patient’s last name without watching Excel Video 155. The LEFT function has two parameters. First, enter the text string you want to extract text from, which in our example is the cell with the patient’s full name. Then,...

Excel Video 154 FIND and LEN

Excel Video 154 is short and easy. I’ll introduce two functions, FIND and LEN. FIND looks for a text string inside another text string. I use FIND to look for text inside a cell, and the most common thing I look for is a comma that separates a last name from a first...

Excel Video 153 EXACT

Excel Video 153 might be EXACTly what you need to make your life easier. EXACT is a simple Excel function that compares two text strings (say the text in two different cells) to see if they’re exactly the same. Today’s trick is to combine EXACT with CONCATENATE from...