Extract First and Last name from a string in a cell. Hope there is a function in EXCEL to do this
Posted on 2014-09-04
I have a string value in a cell from Active Directory. In a recent question I was able to extract the full name from this string
CN=John Doe,CN=Users,DC=mydomain,DC=int Using this function. =MID(A1,4,FIND(",",A1)-4). And it works great.
Now I would like to extract the first name and last name, each in its own cell. In other words, "John" in the B1cell and "Doe" in the C1 cell. This way I can import to a database table. Any help is greatly appreciated.