Forum Discussion
Concat Function
Hi I am trying to use formula to create product name. Here is my data: Brand Material 1 Series Product Material 2 Size Shape Color NRS Pure Vanilla Extract 100ml ...
If you have Microsoft 365 or Office 2021, or use Excel in the browser or on iPhone/iPad/Android:
=TEXTJOIN(" ", TRUE, B4:I4)
