Post a New Question

Excel

posted by .

Say this is my cell:
2013 *aaron e. pacheco*9743 2nd Avenue*Boca 33431 *pacheco@fau.edu*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...

Answer This Question

First Name:
School Subject:
Answer:

Related Questions

More Related Questions

Post a New Question