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

yogi_Compute For Flights Ground Time In Hours Minutes And Difference In Arrival And Departure In Minutes From Estimated Times

                                          Google Spreadsheet   Post  #911

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Dec 3, 2012

user googledocsfan said:(http://productforums.google.com/forum/#!category-topic/docs/spreadsheets/MzZjbKi__1c)
Formulas for airplane ground-time / delay minutes. Help! :) Examples included. 

Hello there!  I would like to request someones help in this important project of mine.  I currently am doing this work via Excel.  The excel file is attached.  I am trying to convert this work to the cloud via google docs!

Your help is greatly appreciated.

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

I did not create this excel file myself, so I have a hard time understanding several of the formulas it is using.  In both excel and google link, columns A-E are manual input.  F - I are also manual input in 24-hr time format.  Columns J, K, M, are the results I am trying to achieve.  In the excel file columns P-S also contains formulas that are linked with the current formulas in J K M, not sure why or how. ;)

Also to mention, in excel, I can easily type "2200" and when in move to the next cell, it will automatically turn into "22:00".  Can the same thing be done via google docs?

Once again THANK YOU ALL in advance for your insight.  Please feel free to visit the google docs link above and compare it to the excel file attached. 

Mahalo from Hawaii!

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

following is a solution to the problem