How to Combine text in excel column using Textjoin

48 Views Asked by At

Sorry My english So bad. I want to combine data in 2 row.

=TEXTJOIN("",true,G4:G12,"")

Image

enter image description here

1

There are 1 best solutions below

0
On

Use TEXTJOIN() like-

=TEXTJOIN("*",TRUE,B2&$C$2:$C$4)

enter image description here