98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » List of names in a table
List of names in a table
Resolved · Low Priority · Version 2003
Jo has attended:
Excel Intermediate course
List of names in a table
Is it possible to order, alphabetaically, names that have been put into on cell by surname or do you have to have two separate cells, eg one for forename and one for surname? (hope that makes sense!)
RE: List of names in a table
Hi Jo
Thank you for your question - and it does make sense :)
You would need to separate first and last names into their own columns. This makes it easy to sort by last name and do things like mail merge. An alternative might be to write some VBA programming code to sort records that have both firstname and lastname in the same cell.
I hope this helps - do let us know if you have any further questions.
Kind regards,
Andrew
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Difference between Two DatesThe DATEDIF function computes the difference between two dates. The DATEDIF function is as follows: |