yogi_Split Strings in Column A To Numbers Street_Addresses And Names Row By Row As Specified

                                          Google Spreadsheet   Post  #945

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Dec 29, 2012
user googledocsfan 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!!!!!!!!!!

---

When you can, could you please look at this shared file?

https://docs.google.com/spreadsheet/ccc?key=0Aqdd8WsdTHRvdFNwcGRRNE00SFJqN282eGJyQmo2VlE

I am trying to produce the results as displayed inside this file.  Please feel free to work within this file.

Your assistance is greatly appreciated as always.

Aloha!

--------------------------------------------------------------------------------------------

following is a solution to the problem