posted by Dom .
Say this is my cell:
2013 *aaron e. pacheco*9743 2nd Avenue*Boca 33431 *firstname.lastname@example.org*9049
how would i use the text function to extract the first, middle, and last names from a list of cells like the one above with differing name lengths? and possibly some without middle names?
I'm having trouble using the LEN and Right functions...