Forum Discussion
Anonymous
8 years agoNot applicable
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!
- Anonymous8 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
- AnonymousNot 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
- AnonymousNot applicable
Works like a charm! Thank you Parker!