sortingfiltering

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

TrustPilot

starstarstarstarstar Excellent

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Sorting/Filtering

Sorting/Filtering

resolvedResolved · Low Priority · Version 2003

Catharine has attended:
Excel Intermediate course

Sorting/Filtering

Is it possible to sort by surname if the surname and first name are together in one name field rather than in 2 seperate fields?

RE: Sorting/Filtering

Hi Catharine

Thank you for your question; and welcome to the forum.

If you wanted to sort by surname, surname and first name will need to be in separate columns.

I hope this helps.
Amanda


 

Excel tip:

No Zeros

Want all the zeros in your worksheet to appear blank? Choose Tools/Options, Click on the View Tab, Deselect the Zero Values Option, Click OK.
Easy wasn't it? But be aware that these cells are not actually blank, they still contain the value zero. This is important because certain functions (ie AVERAGE) make a distinction between blank cells and those with a zero value.

View all Excel hints and tips


Server loaded in 0.08 secs.