SeaTable formulas offer you several ways to work with the data in your tables. One of them is merging content from different text columns. Using an appropriate formula, you can merge any number of contents from different columns into one formula column.
Merge text columns #
In the concrete example, the goal is to use a formula to merge the contents (last name, first name & title) of the first three text columns into a complete name.
To do this, first add a formula column to the table, in whose text field you can then add any formula.
To merge content from different text columns into one column, you must always refer to the names of the columns in which the corresponding text content can be found in your table. It is especially important that the column names are framed with curly brackets, otherwise SeaTable cannot recognize which contents are to be merged.
To merge the contents of the text columns into a formula column, first arrange the column names in the desired order in the formula and separate each of them with an & symbol, which you can find in the formula editor under the Operators tab.
To merge the different contents in the formula column separated by a space, add an & symbol and two quotation marks (above) after the first two column names.
After confirming the entered formula, the contents of the text columns are automatically merged and the formula result appears automatically in the formula column.
trim( {Title} & " " & {Surname} & " " & {Name} ).