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.

Surface Pro (2017) vs Surface Pro 4

20 groundbreaking 3D animation techniques

How to mine Bitcoin on Mac