Google Sheets will calculate the number of miles between addresses which is needed for my dispatch and management program. It is handy as there is an autofill function in GoogleSheets/Appsheet and (I assume) needed format for Google Maps which calculates the (also needed) distances. But, it is in a comma delineated format within a single cell.
From the parent table, I would like to prepare a series of letters & emails using table data. To format the data, I need to be able to take the comma delineated data within the address cell and extract to separate lines, address, city, and state/zip.
Where could I find instructions on the template formatting that will allow me to extract from a cell to multiple document or template lines?
Google Sheet: 2010 Sandberg, Austin, TX, 78767
Template Doc: 2010 Sandberg
Austin, TX 78767
LinkedIn
Twitter
