Choose Language Hide Translation Bar
Highlighted
bhuokimo
Level I

How to combine two items by formula edit?

As title, I want combine "Item" &"Test list"

ex: I wonder the new column as "Cu solution-8540A" by using formula

Please teach me ,many thanks! 

3742_111.png

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
ms
Super User ms
Super User

Re: How to combine two items by formula edit?

Use the function Concat, which is equivalent to the operator ||. It is found under Character functions in the formula editor.

This formula should give the desired result

:Item||"-"||:Test List

View solution in original post

2 REPLIES 2
Highlighted
ms
Super User ms
Super User

Re: How to combine two items by formula edit?

Use the function Concat, which is equivalent to the operator ||. It is found under Character functions in the formula editor.

This formula should give the desired result

:Item||"-"||:Test List

View solution in original post

Highlighted
bhuokimo
Level I

Re: How to combine two items by formula edit?

Thanks a lot for my question! It's very clear.

Article Labels

    There are no labels assigned to this post.