Forum Discussion
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 fin...
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
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
Works like a charm! Thank you Parker!