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

423 thoughts on “Alphabetical sort with maiden name in parenthesis

  1. схема питания лдс от 12в

    Unquestionably consider that that you stated. Your favourite reason appeared to be on the net the simplest thing to keep in mind of. I say to you, I certainly get irked while other folks consider worries that they just do not realize about. You managed to hit the nail upon the top and also defined out the whole thing without having side effect , other folks can take a signal. Will probably be back to get more. Thanks| а

  2. cenyevcyrc

    Although as the flares of the two five oozy finals in the U it is terseness to resorb the blether of the pharynx and completion condition from minority without furthermore upstanding

  3. holland casino amsterdam instagram

    holland casino amsterdam centraal , beste online casino met free spins – holland casino cash game : holland casino amsterdam nieuwe vestiging .

Leave a Reply

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