Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- JMP User Community
- :
- Discussions
- :
- How to combine two items by formula edit?

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

Highlighted

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Created:
Jun 23, 2013 11:54 PM
| Last Modified: Oct 18, 2016 1:13 PM
(6771 views)

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!

1 ACCEPTED SOLUTION

Accepted Solutions

Highlighted

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

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 2

Highlighted

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

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*

Highlighted
##

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

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.