Subscribe Bookmark RSS Feed

How to combine two items by formula edit?

bhuokimo

Community Trekker

Joined:

Jun 23, 2013

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
Solution

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

2 REPLIES
Solution

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

bhuokimo

Community Trekker

Joined:

Jun 23, 2013

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