RattlingCarp3048
Board Regular
- Joined
- Jan 12, 2022
- Messages
- 183
- Office Version
- 365
- Platform
- Windows
I have a set of names i need to reformat. normally i would just separate out the names into helper columns and concat what i need from there. in this particular case i cannot do that. Sooo i have this formula which is close but not quite. Can someone help get me over the finish line?
C3 >>>A3
Snow, John F >>>John Snow
Snow, John >>>> John Snow
Snow Targaryen, John F >>> John Snow Targaryen
=MID(C3,SEARCH(",",C3)+1,LEN(C3)-SEARCH(",",C3)-1)&" "&LEFT(C3,SEARCH(",",C3)-1)
currently if there is no middle initial it is cutting off the last letter of the first name instead
C3 >>>A3
Snow, John F >>>John Snow
Snow, John >>>> John Snow
Snow Targaryen, John F >>> John Snow Targaryen
=MID(C3,SEARCH(",",C3)+1,LEN(C3)-SEARCH(",",C3)-1)&" "&LEFT(C3,SEARCH(",",C3)-1)
currently if there is no middle initial it is cutting off the last letter of the first name instead