hello i have a simple question i hope somebody can help me out.
i have a long list of first name and last name in the same cell and the order of it is first name and afterwards last name.
i was wondering if there is a formula of some sort that will change the position of the text inside the cell so it will be last name then first name instead.
i hope i have made myself clear enough.
thanks for the support.
Amir
Please attach a sample file with dummy data.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
If you simply want to change FIRST LAST to LAST FIRST (no comma, and always one first name and one last name) then assuming your list is in A1:A100, in B1 use:
=MID(A1,FIND(" ",A1)+1,LEN(A1))&" "&LEFT(A1,FIND(" ",A1)-1)
Fill that down to B100. Then copy B1:B100, select A1 and choose PasteSpecial > Values. You can then delete column B.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks