Wednesday, July 2, 2014

yogi_Split Into Different Rows Name_StreeAddress_Unit_CityStateZip With Each Entry Into Different Lines In The Same Cell

                                      Google Spreadsheet   Post  #1687
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jul-02-2014
post by Johnkyle Ratkovich: (https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/s-hu8oV_Npo)
split function for a mailing address
i have a list of mailing addresses that get populated each day with new addresses from other sheets. each address,city,state,zip are all in a cell and i want to seperate them out. example:
a1 is 
john smith
1234 e. main st.
unit 8
los angelas, ca 123456

i would like it to be like this
example:
a1= 1234 e. main st. (aka the hose number and street name and unit if applicable)
b1= city
c1=state
d1=zip
------------------------------------------------------------------------------------------------------------------------------------------------