Excel Forum



Excel Magic Trick 559: Extract Nth Word In Text String


See how to Extract First, Last or Nth Word In Text String using the following functions:
SUBSTITUTE, LEN, SEARCH, REPLACE, LEFT, RIGHT, MID.





Got a Question? Ask it Here in the Forum.