| Unformatted Addresses |
| 27th Ave, Queens, NY 11102 |
| 1975 Bathgate Ave, Bronx, NY 10457 |
| 1242 Abbott Blvd, Fort Lee, NJ 67024 |
| 899 Teller Ave, Bronx, NY 10451 |
| 614 59th St, Brooklyn, NY 11220 |
| 41 W 96th St, New York, NY 10025 |
| 155 W 2nd Ave, Roselle, NJ 75203 |
| 17 Windsor Rd, Summit, NJ 57901 |
| 11 Ashland Rd, Summit, NJ 79016 |
| 203-18 32nd Ave, Flushing, NY 11361 |
function extractAddresses () {
var sheet, range1, range2, range3, range4, range5;
var commaPos1, commaPos2, counter;
sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
// 27th Ave, Queens, NY 11102
// 01234567890123456789012345
range1 = sheet.getRange(2, 1);
range2 = sheet.getRange(2, 2);
range3 = sheet.getRange(2, 3);
range4 = sheet.getRange(2, 4);
range5 = sheet.getRange(2, 5);
completeAddressArray = range1.getValues ();
completeAddress = completeAddressArray[0][0];
range2.setValue ("Some Address");
range3.setValue ("Some City");
range4.setValue ("Some State");
range5.setValue ("Some Zip");
}
// Use the following to reference a specific sheet. For example, to
// reference the sheet "Tutorial".
sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Tutorial");