• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Separating data into 2 columns take 2 :)

A

ashleem

New Member
I have a name column in my spreadsheet that I want to separate into two columns,a firstname+middle column(Name1) and a lastname+title column (Name2) . Not all of the names in the current Name column are formatted the same (i.e. some people don't have middle initial or have 2 middle initials). Is there a way I can separate the names into two separate columns?


Here is an example of what I have in contrast of what I'd like to achieve:

https://docs.google.com/spreadsheet/ccc?key=0AhBEhkKA8pwWdEZiQ3lCMkJBaEpxLTBaR1RDWDF4S1E#gid=0
 
Hi, ashleem!

Would you please grant access to your uploaded file? Thank you.

Regards!

PS: BTW, this is the continuation of your same previous thread:

http://chandoo.org/forums/topic/separating-data-into-2-columns

so you can (you must) go on posting on the same topic writing within the Reply box at its bottom. If not, the questions and answers to your issue will be spread between a lot of topics. Just advise if need any help about this.
 
You must log in or register to reply here.
Back
Top