Alphabetical sort with maiden name in parenthesis

I am using Excel 2007 on a PC.

I’m using the following formats to enter names in the same column:

1. Last name, First name  – for males and single women

2. (Maiden name) Last Name, First name – for married women

When I sort the column A-Z all the entries that start with ( ) come to the top of the list and the rest go to the bottom. So I’m not getting a true alphabetized list.

I need to have the entries with the (maiden names) fall in alphabetical order with all the other non-( ) listed names.

I tried using brackets [ ] and the list sorts the same way. 

How can I sort this list to achieve the result I need? Or what syntax will help me do this.

I really want the maiden name to be somehow separated using ( ) or [ ].

By: Annie Donovaro

536 thoughts on “Alphabetical sort with maiden name in parenthesis

  1. Assista Iptv Apk

    Ponto IPTV a melhor programacao de canais IPTV do Brasil, filmes, series, futebol, lutas, shows, documentarios em alta definicao de imagem e som em SD, HD, FULL HD, 4K. compativel com todos aparelhos do mercado Brasileiro.

  2. Sewa Bus Pariwisata Jakarta

    Woah! I’m enjoying the template/theme of this website. Is actually simple, yet effective. A new lot of times it is rather hard to get of which “perfect balance” between exceptional usability and visual attractiveness. I must say you might have done a very excellent job on this.

  3. jasa backlink manual

    Write considerably more; that’s all I include to say. It appears as though you counted on the video to be able to make your point. An individual know what you’re speaking about, why waste your intellect on just posting video clips to your blog if you may be giving all of us something enlightening to study?

  4. air force 1

    I’m also commenting to let you be aware of what a terrific discovery my child went through reading through your web site. She mastered a wide variety of issues, with the inclusion of how it is like to possess an amazing coaching style to make the rest with ease know certain tortuous subject matter. You really exceeded visitors’ expected results. Many thanks for producing those priceless, trusted, revealing and even fun tips on this topic to Evelyn.

  5. traveling di bandung

    Howdy, would certainly you mind letting me personally know which web web host you’re utilizing? I’ve filled your blog in a few completely different web windows, and I must state this blog loads significantly faster then most. May you suggest a great internet hosting provider at the reasonable price?

  6. образец заявления о пересмотре решения по вновь открывшимся обстоятельствам

    What i don’t understood is if truth be told how you are not really a lot more well-favored than you may be right now. You are so intelligent. You understand thus considerably in relation to this topic, produced me individually imagine it from numerous varied angles. Its like men and women aren’t fascinated unless it is something to accomplish with Girl gaga! Your individual stuffs outstanding. All the time maintain it up!| а

  7. produksicetak

    I’d personally love to be a new part of group in which I can get guidance from the other experienced people that will share exactly the same interest. In case you have any advice, please let me understand. Thank you.

  8. lebron james shoes

    I must express my respect for your generosity in support of all those that need help on this field. Your very own dedication to getting the solution throughout has been really beneficial and has encouraged ladies much like me to arrive at their targets. This important recommendations implies much to me and even more to my office colleagues. Thanks a lot; from everyone of us.

Comments are closed.