Generate Project Location Codes
I need to combine the 'Site ID' and 'Zone Code' with a hyphen to create a unique location identifier.
=CONCATENATE(A2,"-",B2) How it works: The CONCATENATE function joins multiple text strings or cell values into one. In this scenario, `A2` provides the 'Site ID', `"-"` inserts a literal hyphen, and `B2` provides the 'Zone Code'. The function combines these three elements in the specified order to create a unique, easy-to-read project location code.
Data Setup
| Site ID | Zone Code |
|---|---|
| SIT001 | ZNE01 |
| SIT002 | ZNE02 |
| SIT003 | ZNE03 |
| SIT004 | ZNE04 |
Step-by-Step Guide
Open your Excel sheet containing 'Site ID' in column A and 'Zone Code' in column B.
Select the cell where you want the first combined location code to appear (e.g., C2).
Type the formula: `=CONCATENATE(`
Click on the cell containing the first 'Site ID' (e.g., A2).
Type `,"-"` to add a hyphen as a separator.
Click on the cell containing the first 'Zone Code' (e.g., B2).
Type `)` to close the CONCATENATE function.
Press Enter to see the combined location code.
Drag the fill handle (the small square at the bottom-right of cell C2) down to apply the formula to the rest of your data.