Excel does not support the same curly brace syntax for entering arrays of mixed text and formulas as Google Sheets does. However, there are ways to achieve a similar effect in Excel, such as ensuring that your formula always recalculates and stays in the correct row.

Scenario 1: Add a Header

In the first row (e.g., A1), type your header, like Names.

Scenario 2: Enter the Formula in the Second Row In the cell below the header (e.g., A2), type this formula

=TEXTJOIN(",", ,E1:F1)

This will combine the values in E1 and F1.

Scenario 3: Lock the Formula for Reuse

If you want the formula to always refer to E1:F1 no matter where it’s copied or dragged, update it to

=TEXTJOIN(",", ,$E$1:$F$1)

Scenario 4: Use Excel Tables to Automate

Select your data and press Ctrl + T to convert it into a table. Excel will automatically apply the formula to new rows in the table.