Sunday
December 21, 2014

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

Javascript - I need help these javascript exericses: Input: A text string, using...
JavaScript - I need help these javascript exericses: Input: A text string, using...
Excel - I have my employee schedule in a excel sheet. It is a weekly schedule ...
managerial economics - my cubic equation is O=C+aL+bL^2+cL3 how can i get the ...
Finance - On August 1, 2005 you invested $3,000 into a mutual fund. You then ...
Javascript - Input: A text string, using prompt. Output: Either "Valid name" or...
Critical to life is the function of the cell membr - living organisms require ...
Bio/CHEM - 11. You need to make a 1:8 ratio of DNA of two DNA types A and B (A:B...
English - 1. Use tips to answer the questions with your partner. (What is the ...
Can someone check my answer please - Can someone check this for me? Suppose that...

Search
Members