Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Combine text from multiple columns into one

Hi Community,

I need to combine text from three different columns as shown below. The first table shows three columns that I need to combine. I need to add text and punctuate  so each row in the final column looks like this: Name - PO#1234 - End Date 10/22/2017 Also as shown in the small table below the first one in the example below.

Appreciate your help!

  • Anonymous's avatar
    Anonymous
    8 years ago

    Hey Anonymous

     

    A couple of options for you:

     

    Column = Table[Name] & " - PO#" & Table[PO #] & " - End Date " & Table[End Date]

    Or...

     

    Column = 
    COMBINEVALUES(
    " - PO#", COMBINEVALUES(" - End Date ", Table[Name], Table[PO #]),
    Table[End Date]
    )

     

    Hope this helps,

    Parker

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hey Anonymous

     

    A couple of options for you:

     

    Column = Table[Name] & " - PO#" & Table[PO #] & " - End Date " & Table[End Date]

    Or...

     

    Column = 
    COMBINEVALUES(
    " - PO#", COMBINEVALUES(" - End Date ", Table[Name], Table[PO #]),
    Table[End Date]
    )

     

    Hope this helps,

    Parker

    • Anonymous's avatar
      Anonymous
      Not applicable

      Works like a charm! Thank you Parker!