You can use the following formula for names without any middle name:
=MID(A1,SEARCH(" ",A1,1)+1,1)&" "&LEFT(A1,SEARCH(" ",A1,1)-1)
You can use the following formula for names without any middle name:
=MID(A1,SEARCH(" ",A1,1)+1,1)&" "&LEFT(A1,SEARCH(" ",A1,1)-1)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks