Sunday
March 29, 2015

Homework Help: Excel

Posted by Dom on Tuesday, July 9, 2013 at 10:00pm.

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

Critical to life is the function of the cell membr - living organisms require ...
science - Which of the follow comparisons would be an inaccurate analogy between...
biology - Which of the follow comparisons would be an inaccurate analogy between...
Excel - I have my employee schedule in a excel sheet. It is a weekly schedule ...
Science/Math - I have to figure out what percentasge of time each cell is in a ...
Javascript - I need help these javascript exericses: Input: A text string, using...
JavaScript - I need help these javascript exericses: Input: A text string, using...
prokaryotic/cells - We just got through with a lab and we looked at ecoli, ...
human anatomy and physiology - 4. living organisms require energy to function ...
human anatomy and physiology - living organisms require energy to function and ...

Members