Sunday, September 7, 2014

yogi_Split A Cell By Multiple Critria

                      Google Spreadsheet   Post  #1753
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   Sep-07-2014
post by Christopher Neu:
Split a cell by multiple criteria
I am trying to make a meeting tracker using a Google form for someone.  The fields will include who was in attendance and meeting notes.  The meetings will have a varying number of attendees.  To simply the input I am telling the person to input the attendees by "FirstName LastName (Company Name), FirstName2 LastName2 (Company Name 2)" in succession in one field.  I know how to perform a split by one delimiter (in this case the comma) but m wondering how to be able to separate the values into three columns so that each row has:

     A                   B                  C                   D                  E
1   Meeting#      MeetNotes    FirstName     LastName    CompanyName
2                                             FirstName2   LastName2  CompanyName2

The meeting# field will be done from a dropdown of the meetings and the MeetNotes will be populated from that selection via index(match()).  I have no doubt I can sort out matching up the attendees correctly as well but I just cant get the attendees to properly split as needed.  Any help would be fantastic.  

Thank you in advance,

Here is a link to the test sheet I am working with: