公式库

Excel Formula To Join Cells With A Dash

Join cells with a dash with a ready-to-use formula for Excel, Google Sheets, and WPS.

快速答案

Join cells with a dash.

统一公式

ExcelGoogle SheetsWPS

=TEXTJOIN(", ", TRUE, A2:D2)

使用说明

将示例区域（如 A2:A）替换为你的实际区域。
保持与示例一致的列顺序。
向下填充以应用到所有行。

需要定制版本？

相关公式

Excel Formula To Join Cells With Commas

Join cells with commas with a ready-to-use formula for Excel, Google Sheets, and WPS.

Excel Formula To Join Cells With Spaces

Join cells with spaces with a ready-to-use formula for Excel, Google Sheets, and WPS.

Excel Formula To Join Cells Into One Cell

Join cells into one cell with a ready-to-use formula for Excel, Google Sheets, and WPS.

Excel Formula To Join Cells With A Slash

Join cells with a slash with a ready-to-use formula for Excel, Google Sheets, and WPS.

Excel Formula To Join Columns With Commas

Join columns with commas with a ready-to-use formula for Excel, Google Sheets, and WPS.

Excel Formula To Join Columns With Spaces

Join columns with spaces with a ready-to-use formula for Excel, Google Sheets, and WPS.