This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I have a spreadsheet with three columns that I would like to merge into 1 with dashes in between. This issue is that there is not always information in all three columns so I assume I need some sort of nested "if" function. Can someone please help?
| Column 1 | Column 2 | Column 3 | Should Result: |
|---|---|---|---|
| 5500 | 100 | 5500-100 | |
| 4560 | 1012 | 4560-1012 |
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Do you have Excel in Office 2019, Office 2021 or Microsoft 365? If so, you can use the following formula in D2, then fill down:
=TEXTJOIN("-",TRUE,A2:C2)