Search code examples
google-sheetsconcatenationgoogle-sheets-formulaarray-formulas

Problem with Array Formula and Concatenate

I'm trying to build an array formula on google sheets for this :

=CONCATENATE(MID(C2,4,3),(MID(C2,1,3)),MID(C2,7,4))

The problem is that when I use array formula going from C2:C, it will concatenate all the rows at the same time, which is not what I want.

Does anybody know how to properly use the array on that case? So it will keep looking for just the value on C2, C3,C4 and so on?

Thank you!

Solution

  • Use the ampersand character instead of CONCATENATE:

    =ArrayFormula(IF(C2:C="", "", MID(C2:C,4,3)&(MID(C2:C,1,3))&MID(C2:C,7,4)))