Extracting a text in simple way:

We can extract a word or a particular text from a line in a simple way using the below referred formula.





In the above example, we have name of persons in the cell A1 to A3 and we have extracted the name of persons in the cell B1 to B3. We have used =SUBSTITUTE(A1,"Last Name: ","") formula to do that. This formula substitutes the text “Last Name: ” with a null value “”.