Ask a New Question

Question

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...
12 years ago

Answers

Related Questions

Let S={1,2,3,4,…,2013} and let n be the smallest positive integer such that the product of any n dis... 2. In 2013, an initiative in Uruguay was started in order to reduce the risk of which type of natur... On January 10, 2013, Mia went to the library to gather information for her research paper on the eff... 13 of 2013 of 20 Items 06:14 Question "This sophism derives muc... 13 of 2013 of 20 Items Question The ______________ lies off Australia’s northeast coast and... 13 of 2013 of 20 Items Questi... 13 of 2013 of 20 Items Question Which of the following c... 13 of 2013 of 20 Items Question Which is an example of the bandwagon type of propa... 13 of 2013 of 20 Items Question What is the quotient of 954x ?(1 point) Responses... 13 of 2013 of 20 Items 05:55 Question The Chattahoochee River runs fr...
Ask a New Question
Archives Contact Us Privacy Policy Terms of Use