Hello,
I would like a formula that concatenates address information from 3 columns (A, B, & C) and outputs the result into column D but with the following structure:
- anywhere a space is detected in between a string, insert a dash "-"
- an underscore "_" is inserted after the street address from column A (used to differentiate street address from City & State (columns B&D)
- everything is output in lowercase
Please refer to the Desired Outcome in the table below
I would like a formula that concatenates address information from 3 columns (A, B, & C) and outputs the result into column D but with the following structure:
- anywhere a space is detected in between a string, insert a dash "-"
- an underscore "_" is inserted after the street address from column A (used to differentiate street address from City & State (columns B&D)
- everything is output in lowercase
Please refer to the Desired Outcome in the table below
| Book1 | ||||||
|---|---|---|---|---|---|---|
| A | B | C | D | |||
| 1 | Street Address | City | State | Desired Outcome | ||
| 2 | 123 Main Street | New York | NY | 123-main-street_new-york-ny | ||
| 3 | 541 Easy Street | Miami | FL | 541-easy-street_miami-fl | ||
| 4 | 987 Golden Goose Dr | Los Angeles | CA | 987-golden-goose-dr_los-angeles-ca | ||
Sheet2 | ||||||
