Friday, May 27, 2016

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