Use the Concat Function to Merge Two Fields and Insert Space or Text Between Them

Scenario

User wants to merge two fields and insert a text or space in between them when displaying the search results.

Solution

1. Navigate to Lists > Search > Saved Searches > New
2. Click Search Type as necessary
3. Search Title: Enter Title
4. Click Results
5. Click Columns
6. Field: Select Formula (Text)
• Note: Enter any of the given formula below in the Formula field to insert a space between the fields.
• Formula: Enter CONCAT(CONCAT({custfield1}, ' '),{custfield2})
• Formula: Enter ({custfield1})||' '||({custfield2})
7. Field: Select Formula (Text)
• Note: Enter any of the given formula below in the Formula field to insert text between the fields.
• Formula: Enter CONCAT(CONCAT({custfield1}, 'Text'),{custfield2})
• Formula: Enter ({custfield1})||' Text '||({custfield2})
8. Click Save & Run