Forum Discussion
LaurieCS3705
Dec 02, 2022Copper Contributor
COMBINING TEXT VALUES TO 1 CELL ON SEPERATE WORKSHEET
Worksheet has 4 seperate columns to track payments from different sources. I need to combine all the "titles" of these cells into 1 cell to indicate the "source" of the payments. should a...
mtarler
Dec 02, 2022Silver Contributor
Those options SHOULD work (along with TEXTJOIN). I'm not sure why they aren't working for you and need to see the sheet and have more info to figure out. For example is this all in a big table and those 4 columns are all in that same table? What exactly are the formulas you tried? Is the "table" of data you are pulling from and/or putting the formula "Formatted as a Table"?