Extracting a text in a sentence:

If you would like extract a particular word from a sentence or from a line. We can do that in excel, please look into the below examples and formulas.




In the above example we have name of person in cell A1 in the order of Last Name and First Name and we had extracted the last name “David” alone using =MID(A1,12,5) formula. The first 12 characters build the word “Last Name: ” and the next 5 characters contains the last name. The formula extracted five characters (David) after 12 characters from left.