Hello all,
Do you guys know how to turn around the name and surname of a person.
ie: "Brown, Jonathan" into "Jonathan Brown"
I am going to apply the code on a whole column.
All help is welcome.
Hello all,
Do you guys know how to turn around the name and surname of a person.
ie: "Brown, Jonathan" into "Jonathan Brown"
I am going to apply the code on a whole column.
All help is welcome.
Last edited by Jonathan78; 03-02-2011 at 06:26 AM.
hi, check attachment file
PS. Comma must be always there
Awesome, thanks Waterdev
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks