View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
dan dan is offline
external usenet poster
 
Posts: 113
Default Parsing Full Names of varying lenths and parts

I am attempting to parse a Full name that includes First,
Middle, Last and some times PHD, MR or MRS.

I have the first name that was a left with a nested search
but search only works from left to right. I would like to
use right and some function that counts number of chactors
until reaching the space to the left of the last name.

Any Idea?s