Excel Alpha order of Names & Addresses

  David4637 09:44 05 Feb 2011
Locked

I have 3 columns with data as follows -
Col A First Name
Col B Surname
Col C Address
Please advise how I can sort so the surnames are put into alpha order (A to Z) but Col B & C follow correctly for the surname?
Thanks David

  VoG II 10:07 05 Feb 2011

Select all the data, Data > Sort, sort by column B ascending.

  David4637 10:23 05 Feb 2011

Thanks VOG, I almost put in the query if VOG could help, and you have.
Will try your suggestion and report back.
Thanks David

  David4637 12:33 05 Feb 2011

It worked
Thanks very much
David

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

The Evil Within 2 review-in-progress

Photoshop CC 2018 released with new Curvature Pen and better brush tools

Camera tips to take better iPhone photos

Les meilleures applications de covoiturage 2017