-
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.
-
=LEFT(A1,FIND(" ",A1)-1))
=MID(A1,FIND(" ",A1)+1,255)
-
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
-
Forum Rules