Saturday, December 29, 2012

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    Dec 29, 2012
user googledocsfan said:(!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?

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.


following is a solution to the problem