O OAhmed New Member Jun 18, 2012 #1 Hi Chandoo, I want to get rid of Title in a name, which is between First name and initial, something like this: Abrams, Coun K. I just want to get rid of "Coun" to get the result as Abrams, K. Thanks in advance. O Ahmed
Hi Chandoo, I want to get rid of Title in a name, which is between First name and initial, something like this: Abrams, Coun K. I just want to get rid of "Coun" to get the result as Abrams, K. Thanks in advance. O Ahmed
Hui Excel Ninja Staff member Jun 18, 2012 #2 Try: Code: =LEFT(A1,FIND(", ",A1)+1)&RIGHT(A1,LEN(A1)-FIND(" ",A1,FIND(" ",A1)+1))
Try: Code: =LEFT(A1,FIND(", ",A1)+1)&RIGHT(A1,LEN(A1)-FIND(" ",A1,FIND(" ",A1)+1))
