BookmarkSubscribeRSS Feed
Choose Language Hide Translation Bar
bhuokimo
Community Trekker

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

0 Kudos
1 ACCEPTED SOLUTION

Accepted Solutions
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

0 Kudos
2 REPLIES 2
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

0 Kudos
bhuokimo
Community Trekker

Re: How to combine two items by formula edit?

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

0 Kudos