Converting a Formal Name
I'm sure someone out there has an answer for this question, but I just don't know where to look for the answer. Is it possible to convert a formal name, example: Smith, John to John Smith if the entire name is in one cell?
Welcome to the forum!
With
A1 containing a name in the form of: Lastname, Firstname...eg Newman, Alfred E.
This formula returns: Firstname Lastname
In the above example, the formula returns: Alfred E. NewmanCode:B1: =TRIM(MID(A1&" "&A1,FIND(",",A1)+1,LEN(A1)))
Is that something you can work with?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks