Thursday, November 15, 2012

yogi_Split Smith Family List of Names and Addresses Into Names And Addresses


                                           Google Spreadsheet   Post  #872
              Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Nov 15, 2012
user Calendar_crazy said : (https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/cKhOoPp_8DM)
Is there a formula to separate contents of one cell? Please help! :) An example is listed.
Hi fellow google docs users!

I am currently working on massive data entry.  Column A is data I already have.  I am trying to achieve the automatic results of Column B and C.
Is there a formula I can place in Column B to achieve the results of B and C?  The Last Name in column A (currently Smith) will always be the same.
Is there a formula that would split the contents of Column A after the word "Smith" passes?

                  A                                               B                                           C
1   Amber Smith 111 First St                  Amber Smith                       111 First St

2   John Smith 15 Cupcake St                John Smith                           15 Cupcake St      

3   Jane Smith 1556 Paradise Rd            Jane Smith                           1556 Paradise Rd

If this is not possible, I have hours of work to complete.  :P
All of your thoughts and suggestions are greatly appreciated!!!!!!!!!!

------------------------------------------------------------------------------
following is a solution to the problem