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...
could a job title have a "-" in it? that would mess it up
=TEXTBEFORE(TEXTAFTER(TEXTAFTER(A1, " - "),", "), " ") & " " & TEXTBEFORE(TEXTAFTER(A1, " - "), ", ")