Monday
April 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

Excel formula help - Formula to multiply the number in cell 4k times standard ...
Excel - I have my employee schedule in a excel sheet. It is a weekly schedule ...
Science - Is a cell wall on a plant or animal cell or on both?
Data Analysis Help - Arithmetic operations, cell references, and __________ can ...
Excel help - How would I write a formula to multiply the number in cell k4 times...
Algebra - What is the fourth root of 4^4^4? A long wire is cut into three ...
Excel help please - How would I write a formula to multiply the number in cell ...
Excel - How would you write a formula to divide the number in the cell v45 by ...
Excel computers - How would you write a formula to multiply the number in cell ...
Excel & Math - I'm not sure what two excel functions to use that will give the ...

Search
Members