Skip to main content

Add attributes to text fields with the CONCATENATE function

A very simple function to combine texts from different values is the CONCATENATE function. With this function it is possible to link up to 255 different values. If someone thinks that 255 is not enough - no problem: simply use the function CONCATENATE in a new cell and refer to this cell in the first call.

How can this feature be used helpfully for Magento?

One of the most popular use cases we have found is automatically creating meaningful page titles (meta titles).

Procedure​

Step 1: Mark first row​

To do this, we select the first row in the Meta-Title column and switch to the formula bar (note: don't forget to set the cell format to Standard so that the formula is calculated).

Step 2: Enter function name​

Now we enter the equal sign followed by the function name CONCATENATE and a parenthesis on a (=CONCATENATE().

Step 3: Add function parameters​

Depending on which attributes are to be used in the page title, we now add the respective cell names to the function parameters by clicking the column of the attribute from the currently selected row. Each new attribute is separated with a semicolon ( ; ).

Step 4: Put spaces after semicolons​

In the last step, we place a space after each semicolon ( ; ), which is enclosed by double quotation marks " "; . This is necessary so that the attributes are not combined into one long word. We close the formula with a closed bracket and can now look at the result.

In our example, it makes sense to add a fixed text in front of the Shoe Size attribute to put the number in context. To do this, we enter Size in the quotation marks.

Step 5: Apply formula to all rows and save​

So the page title already looks quite ok. By double-clicking on the small black square at the bottom right of the cell, we apply the formula to all rows in this column (copy and paste). Save the products and you're done!