ExcelFlux

CONCAT function

Combines the text from multiple ranges and/or strings, but it doesn't provide the delimiter or IgnoreEmpty arguments.

Text · Excel 2019+

Where can you use it?

Data preparation and reporting teams. Use this group to clean, split or reformat IDs, names and descriptions before using them in reports.

Scenario in the workbook

Build an invoice ID from two segments. CONCAT does not insert a delimiter automatically.

A worked example from the workbook

RowAB
6First valueSecond value
7INV-042X
8A-07B
9PO-118C
Record 1
=CONCAT(A7,B7)

Expected resultINV-042X

See the inputs and instructions for all 3 examples

Copyable formulas

English Excel · en-US
=CONCAT("INV","-","042")
Turkish Excel · tr-TR
=ARALIKBİRLEŞTİR("INV";"-";"042")

Expected result

“INV-042”

Worked examples

Build an invoice ID from two segments. CONCAT does not insert a delimiter automatically.

Open the English sheet. Inputs begin at A6. F7:F9 show the live results and G7:G9 show the original results for comparison.

Row A B
6 First value Second value
7 INV- 042X
8 A- 07B
9 PO- 118C
Case Formula Expected result
Record 1 =CONCAT(A7,B7) INV-042X
Record 2 =CONCAT(A8,B8) A-07B
Record 3 =CONCAT(A9,B9) PO-118C
Microsoft Excel reference