finnstone

asked on

# easy concatenate

need someone to concatenate the rows for me

looking for formula that connects

A1,B1,C1,A2,B2,C2, ..etc to the end

`="("""&TEXTJOIN(""" OR """,,B1:B30) & """)"`

The preceding formula requires Excel 2019 or later, including Microsoft 365. If you have an earlier version of Excel, you will need VBA code.

Perhaps the most straightforward formulas:

F2: =A1&B1&C1&D1&E1

F3, copied down: =F1&A2&B2&C2&D2&E2

If you have the TEXTJOIN function available:

F2: =TEXTJOIN("", FALSE, A1:E1)

F3, copied down: =F1&=TEXTJOIN("", FALSE, A2:E2)

F2: =A1&B1&C1&D1&E1

F3, copied down: =F1&A2&B2&C2&D2&E2

If you have the TEXTJOIN function available:

F2: =TEXTJOIN("", FALSE, A1:E1)

F3, copied down: =F1&=TEXTJOIN("", FALSE, A2:E2)

ASKER CERTIFIED SOLUTION

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds.

**No credit card required.**
ASKER

filezconcantete.xlsx