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...

Respond to this Question

First Name
School Subject
Your Answer

Similar Questions

  1. Critical to life is the function of the cell membr

    living organisms require energy to function and this includes each and every one of the trillions of cells that constitute the human body. Define in detail and use diagrams appropriate to show how cells extract, use and store energy …
  2. human anatomy and physiology

    living organisms require energy to function and this includes each and every one of the trillions of cells that constitute the human body. Define in detail and use diagrams appropriate to show how cells extract, use and store energy …
  3. human anatomy and physiology

    4. living organisms require energy to function and this includes each and every one of the trillions of cells that constitute the human body. Define in detail and use diagrams appropriate to show how cells extract, use and store energy …
  4. Science/Math

    I have to figure out what percentasge of time each cell is in a phase. I have 5 phases. That equal to 36 cells in each phase. 1st phase 20 cells 2nd phase 10 cells 3rd phase 3 cells 4th phase 2 cells 5th pase 1 cell. This is based …
  5. Javascript

    I need help these javascript exericses: Input: A text string, using prompt. Output: Either "Valid name" or "Invalid name", depending on whether the input names fit the required format, which is Last name,first name, middle initial …
  6. Excel

    I have my employee schedule in a excel sheet. It is a weekly schedule that doesn't change week by week, but changes day by day within a week. Every Monday, Tuesday, etc. is the same schedule. In the file are days for Monday, Tuesday, …
  7. Science

    How many cell divisions would it take to produce at least 1,000 cells from one cell?
  8. biology

    Which of the follow comparisons would be an inaccurate analogy between prokaryotic cells and eukaryotic cells?
  9. science

    Which of the follow comparisons would be an inaccurate analogy between prokaryotic cells and eukaryotic cells?
  10. microsoft 2013

    10. David has a small business and is working on an Excel worksheet to help manage his inventory. David realizes cell E14 has the wrong output. To check the problem, David should first select cell E14 and look at the _______ to check …

More Similar Questions