Concat Function

[Rianto950]

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
MP			Spiral Cutter				Green
MP		Select	Extra Coarse Grater				Red
MP		Premium	Zester				Retro Green

I am currently using this formula: =CONCAT(B4," ",C4," ",D4," ",E4," ",F4," ",G4," ",H4," ",I4). If i use this formula, what comes up is: NRS  Pure Vanilla Extract 100ml   (too many spaces between words). I want to create a "proper" product name so if the column material is empty, it will just be skipped and not printed as space.

Will appreciate your kind assistance.

[#2]

@Rianto950

If you have Microsoft 365 or Office 2021, or use Excel in the browser or on iPhone/iPad/Android:

=TEXTJOIN(" ", TRUE, B4:I4) 

[#3]

@Hans Vogelaar 

Thank you very much. It works like a charm.