list names table

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » List of names in a table

List of names in a table

resolvedResolved · 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


 

Excel tip:

Difference between Two Dates

The DATEDIF function computes the difference between two dates. The DATEDIF function is as follows:

=DATEDIF (Date1,Date2,Interval)

Please note that Date1 must be less than (earlier) or equal to Date2

Please note that Interval must be one of the following codes: "d" (in days), "m" (in months), "y" (in years) expressed in quotes


View all Excel hints and tips


Server loaded in 0.09 secs.