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

14 thoughts on “Alphabetical sort with maiden name in parenthesis

  1. suba suba

    cW7wq9 Some actually good content on this web web site, appreciate it for share. A conservative can be a man who sits and thinks, mostly is located. by Woodrow Wilson.

  2. kd shoes

    I抦 impressed, I must say. Actually not often do I encounter a blog that抯 each educative and entertaining, and let me tell you, you have hit the nail on the head. Your thought is excellent; the problem is one thing that not enough persons are speaking intelligently about. I am very glad that I stumbled throughout this in my seek for one thing referring to this.

  3. cbd öl

    Sweet blog! I found it while surfing around on Yahoo News. Do you have any suggestions on how to get listed in Yahoo News? I ave been trying for a while but I never seem to get there! Cheers

Leave a Reply

Your email address will not be published. Required fields are marked *