Asked by Dom
Say this is my cell:
2013 *aaron e. pacheco*9743 2nd Avenue*Boca 33431 *[email protected]*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...
2013 *aaron e. pacheco*9743 2nd Avenue*Boca 33431 *[email protected]*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...
Answers
There are no human answers yet.
There are no AI answers yet. The ability to request AI answers is coming soon!
Submit Your Answer
We prioritize human answers over AI answers.
If you are human, and you can answer this question, please submit your answer.