Dite Morin
Dite Morin

Reputation: 11

How to Combine text in excel column using Textjoin

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

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

Image

enter image description here

Upvotes: 0

Views: 42

Answers (1)

Harun24hr
Harun24hr

Reputation: 36880

Use TEXTJOIN() like-

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

enter image description here

Upvotes: 1

Related Questions