Excel Alpha order of Names & Addresses

  David4637 09:44 05 Feb 11
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 11

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

  David4637 10:23 05 Feb 11

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 11

It worked
Thanks very much
David

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

Nintendo Switch review: Hands on with the intuitive modular console and its disappointing games…

1995-2015: How technology has changed the world in 20 years

Here's what should be coming to Adobe Project Felix in 2017

Apple AirPods review: Apple's beautiful new Bluetooth headphones bring true intelligence to…