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
No comments:
Post a Comment