Consulting

Results 1 to 3 of 3

Thread: Solved: Help with the formula

  1. #1
    VBAX Regular
    Joined
    Dec 2004
    Posts
    93
    Location

    Question Solved: Help with the formula

    Guys, I need help with the formula that takes one of two strings (i.e. First Name and Last Name) from a cell. As you understand the length of strings can be different. So I need one formula that takes the first string from the cell. And another one that takes the second string. There is a space between two strings.

    Thank you in advance.

  2. #2
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,445
    Location
    =LEFT(A1,FIND(" ",A1)-1))

    =MID(A1,FIND(" ",A1)+1,255)

  3. #3
    VBAX Regular
    Joined
    Dec 2004
    Posts
    93
    Location
    Thank you. That's what I need.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •