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

180 thoughts on “Alphabetical sort with maiden name in parenthesis

  1. coach outlet

    Thanks for your whole effort on this website. Betty takes pleasure in managing investigation and it is easy to see why. All of us know all concerning the dynamic way you produce useful information through your web site and even strongly encourage response from others on this matter while our own daughter is without a doubt starting to learn a lot. Enjoy the remaining portion of the year. You are performing a useful job.

  2. vong bi skf

    Wonderful web page. Numerous valuable data here. We are delivering that to several mates ans also revealing inside delectable. And of course, interesting work!

  3. polo ralph lauren

    I wish to express some thanks to the writer just for rescuing me from this particular scenario. As a result of surfing around throughout the search engines and obtaining tips that were not powerful, I believed my entire life was done. Living devoid of the approaches to the problems you’ve resolved all through this posting is a critical case, as well as the kind which might have in a negative way damaged my entire career if I hadn’t noticed your blog. Your primary know-how and kindness in controlling the whole thing was crucial. I don’t know what I would have done if I had not discovered such a step like this. I can also at this time look ahead to my future. Thanks a lot very much for the specialized and result oriented help. I won’t be reluctant to recommend your web site to anyone who wants and needs care on this topic.

  4. vurtil opmer

    I’m still learning from you, while I’m trying to achieve my goals. I absolutely enjoy reading all that is written on your blog.Keep the posts coming. I enjoyed it!

  5. louboutin shoes

    I want to convey my love for your generosity for folks that should have assistance with that idea. Your special commitment to getting the message all-around appears to be astonishingly invaluable and have really permitted guys much like me to achieve their pursuits. This insightful guide denotes much a person like me and especially to my office workers. Many thanks; from each one of us.

  6. sling tv

    Wonderful blog! I found it while searching on Yahoo News.
    Do you have any tips on how to get listed in Yahoo News?
    I’ve been trying for a while but I never seem to get there!
    Thank you

  7. sxmb

    Pretty good post. I just discovered your weblog and wanted to say which i have actually enjoyed browsing your website posts

  8. golden goose sneakers

    I wish to show some appreciation to the writer for bailing me out of such a circumstance. As a result of browsing through the the net and seeing strategies which are not helpful, I believed my entire life was gone. Living devoid of the approaches to the difficulties you have resolved through the write-up is a serious case, and those which could have in a negative way damaged my career if I hadn’t encountered your blog. Your own natural talent and kindness in handling a lot of stuff was crucial. I don’t know what I would have done if I hadn’t come upon such a point like this. I can also at this time look forward to my future. Thanks so much for your specialized and effective help. I will not think twice to refer the blog to any person who desires care about this subject matter.

  9. verthilertva

    My brother recommended I might like this blog. He was totally right. This post actually made my day. You can not imagine simply how much time I had spent for this info! Thanks!

Leave a Reply

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