With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
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 MIwww.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?