Excel Magic Trick 559: Extract Nth Word In Text String

Download Files: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT558-562.xls See how to Extract First, Last or Nth Word In Text String using the following functions: SUBSTITUTE, LEN, SEARCH, REPLACE, LEFT, RIGHT, MID.