 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / December 2004changing name order
How do I change the name order in a mailing list so that the first name is first and the last name is last? Currently, cell contains last name first followed by a comma and the first name(s). Thanks, Liz With mailing list in Column A, try this in B: =RIGHT(A1,LEN(A1)-FIND(",",A1))&" "&LEFT(A1,FIND(",",A1)-1) And drag down to copy, as needed. This should display the names in the order that you requested. However, the cells which display the names actually contain the formulas. If you wish to remove the formulas, and leave only the name data behind, select the column of formulas,and right click and choose "Copy". Then, right click again, and choose "PasteSpacial", then click on "Values", then <OK>.  SignatureHTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- > How do I change the name order in a mailing list so that the first name is > first and the last name is last? Currently, cell contains last name first > followed by a comma and the first name(s). > Thanks, > Liz |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.