Reputation: 11
Sorry My english So bad. I want to combine data in 2 row.
=TEXTJOIN("",true,G4:G12,"")
Image
Upvotes: 0
Views: 42
Reputation: 36880
Use TEXTJOIN() like-
TEXTJOIN()
=TEXTJOIN("*",TRUE,B2&$C$2:$C$4)
Upvotes: 1