Forum Discussion
Convert a title name to different format
Hello, I am trying to change a name string to a new format: If you saw my last post, this is similar where there are three types (has middle name, has middle name letter, or does not have middle n...
If you're on 365, this may be an option for you:
=LET(str,TEXTAFTER(A1," - "),last,TEXTBEFORE(str,","),first,TAKE(DROP(TEXTSPLIT(str," "),,1),,1),first&" "&last)