Forum Discussion
griffanskee
Oct 20, 2023Copper Contributor
Summary of a Sheet
Basically i have a sheet that has a lot of columns on it and i update it frequently each day and i want to take 4 specific columns and put it on a a separate sheet to send to my boss at the end of ea...
SergeiBaklan
Oct 21, 2023MVP
For such sample
If to assume you have only texts and dates in the columns that could be
=TEXTJOIN(", ", 0, TEXT(B3:E3, "mm/dd/yyyy;;") )
if numbers as well
=B7 & ", " & TEXT(C7, "mm/dd/yyyy;;") & ", " & D7 & ", " & E7