yogi_Given A Table Of Contacts Split Entries Into 'FirstName' 'Spouse FirstName' 'LastName'

Google Spreadsheet   Post  #2066

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   May-27-2016

question by: R123R123:

https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/NdMnSbD6gVs;context-place=forum/docs

Split Couple and Single Names from same column

Hi, I have a large sheet consisting of names similar to as seen below, both married couples with the format "(Husband) and (Wife) Last Name" as well as single individuals "First Last". How can I split the married and single names up so that I achieve the desired outcome attached below?

Thank you!

Screen Shot 2016-05-27 at 1.57.33 PM.png

14 KB