How do I seperate a full name field out into three seperate columns?
I tried the following with good success:
With full name in A2
B2 =MID(A2,1,FIND(", ",A2,1)-1) for last name
C2 =MID(A2,FIND(" ",A2,1),FIND(" ",A2,1)-2) for first name
D2 =RIGHT(A2,2) for middle initial - could be a problem if there is no
middle initial
Rod wrote:
The name field is in the following format: Abbott, Susan H.
I would like to break it out into three seperate columns like below.
Last Name First Name Middle Initial
Abbott Susan H.
|