PDA

View Full Version : Solved: Help with the formula



Kaizer
01-22-2007, 06:49 AM
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.

Bob Phillips
01-22-2007, 06:51 AM
=LEFT(A1,FIND(" ",A1)-1))

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

Kaizer
01-22-2007, 06:58 AM
Thank you. That's what I need.