cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
datavis Member
Member

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.

Concantenate.PNG

Appreciate your help!

1 ACCEPTED SOLUTION

Accepted Solutions
Anonymous
Not applicable

Re: Combine text from multiple columns into one

Hey @datavis

 

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

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

Re: Combine text from multiple columns into one

Hey @datavis

 

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

View solution in original post

Highlighted
datavis Member
Member

Re: Combine text from multiple columns into one

Works like a charm! Thank you Parker!

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (1,272)