Contact List - Extract First / Last Name?

2Next

Answers

  • 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.

    thinkspi.com

Sign In or Register to comment.