Is it possible to separate a name in one cell such as John Smith in A1 to John in cell B1 and Smith in cell C1.
I read that by entering =LEFT(A1,FIND("",A1)) into B1 and =MID(A1,FIND("",A1)+1,LEN(A1)) into C1 that would do it. However that returns “J” in cell B1 and “ohn Smith” in C1
Specifying the number of characters for the first string would not work on a list of names were the first string varies in length, so you need a formula that takes everything before the first space as the first string. Is it possible?
Bookmarks