0

Display result in one single cell

Cat

September 19, 2018 09:27

Answered

Follow

Hi,

is there a possibility to get a result in one cell.

Let's say the result with columns would be three columns with:

A B C

Instead I want to show it in a cell like "A|B|C".

 

• Facebook
• Twitter
• LinkedIn

2 comments

• 1
  
  Harry Lewis September 19, 2018 14:10

  Sure.  Let's look at an example.

  If I had this NL function to generate some columns:

  =NL("Columns","Customer","No.")

  I would get this:

  

  If, instead, I used the equivalent NL(Filter) function and placed it within an NP(Join) function:

  =NP("Join",NL("Filter","Customer","No."),"|")

  I would get this:

  

  I hope that gets you pointed in the needed direction.

• 0
  
  Cat September 19, 2018 23:27

  Thanks Harry. Exactly what I needed!