Contact List - Extract First / Last Name?



  • Paul NewcomePaul Newcome ✭✭✭✭✭

    @Melvin Collins The LEN function simply gives the total count of characters contained within a cell. So the basic logic is that the total number of characters minus the number of characters leading up to the space will give the number of remaining characters which is used to determine how many to pull for the RIGHT function.

Sign In or Register to comment.