Excel 2007 Left, Mid, and Find Functions

8 Responses to “Excel 2007 Left, Mid, and Find Functions”

1. MrHelal123 on: 29 March 2010 at 9:53 am

   STEVEN JOHN PAUL GERRARD
   MICHAEL JOHN H ANTHONY SMITH
   SHAUN H NORMAN
   ROGER CLARK

   What is the best method/easiest formula to extract any middle names and last names. Can you please give examples of different formulas.

   What’s the difference between the search and find?

   gracias
2. MrHelal123 on: 29 March 2010 at 10:01 am

   Hi,

   I have seen many different ways to extract middle names and last names. Some are really confusing to figure out.

   Some people use, find and others use search to find a pattern occurring.

   What is the best and easiest way/formula to use to extract middle and last names. I guess the first name is pretty easy as everyone seems to extract the first name using the same formula. What if there is 1,2 or more middle names…

   i,e
3. soldier4242 on: 29 March 2010 at 10:08 am

   Could you have used a right function to find the states?
4. fred75nimmo on: 29 March 2010 at 10:25 am

   Thanks Bro!
5. geertdd on: 29 March 2010 at 11:18 am

   Which function would you use to check for the presence of a comma in the location? Then you could wrap it all in an IF.
6. Sebastian71732 on: 29 March 2010 at 11:19 am

   This tut. Is great! But i have one question. What if there is more then one slash (/). how can you navigate from only the first?
7. pocketpride on: 29 March 2010 at 12:07 pm

   Yeah you’re right. wit text to columns it’s easier. But it’s good to learn about those mid left functions
8. JFK1980HH on: 29 March 2010 at 12:26 pm

   Isn’t it MUCH easier with the “Data – Text To Columns – delimited by commas” function?