Ravindra BagaleCourses & study guides Track your progress

Guides

Excel मध्ये Text Join कसे करायचे (&, CONCAT, TEXTJOIN)

By , Excel & Data Analytics trainer LinkedIn Published: Last updated:

Read this guide in: English · मराठी · हिंदी

Excel मध्ये text join करा &, CONCAT, किंवा TEXTJOIN ने — वेगवेगळ्या cells मधून full names, city–area labels, किंवा comma-separated lists.

मित्रांनो, first name एक cell, last name दुसरा — एक line हवी. & जलद; TEXTJOIN lists साठी चमकतो. Customer sheets आणि address lines. Tiny examples, मग fill down.

थोडक्यात उत्तर

Vertical steps:

  1. Simple: =A2&" "&B2 (First + space + Last).
  2. अनेक pieces: =CONCAT(A2," ",B2," — ",C2).
  3. Range commas सह: =TEXTJOIN(", ",TRUE,A2:A5).
  4. TEXTJOIN मध्ये TRUE — blanks skip.
  5. प्रत्येक customer row fill down.
  6. Dates/numbers साठी TEXT() जर fixed format हवा.
=A2&" "&B2
=TEXTJOIN(", ",TRUE,A2:A5)

Language: English · मराठी · हिंदी

Before आणि after

Before

First Last City
Riya Shah Mumbai
Om Patil Pune

After (Full name)

Full name
Riya Shah
Om Patil
Before join text Names split across columns.

Before

After join text Full names joined with space.

After

Text join का?

  1. Mail merge आणि WhatsApp lists ला एक “Full name” column हवा.
  2. City आणि Area वेगळे राहतात — label जोडावा लागतो.
  3. Reports ला readable combined fields.

प्रत्येक tool काय करतो

& (ampersand)

=A2&" "&B2
  1. Values डावीकडून उजवीकडे चिकटवतो.
  2. Space साठी " ".
  3. दोन-तीन pieces साठी छान.

CONCAT

=CONCAT(A2," ",B2," — ",C2)
  1. तोच idea, function नावाने.
  2. अनेक pieces असताना स्वच्छ.

TEXTJOIN

=TEXTJOIN(", ",TRUE,A2:A4)
  1. Delimiter = ", " items मध्ये.
  2. TRUE = empty cells skip.
  3. Vertical list साठी ideal.

काय होतं (tiny)

  1. A2=Riya, B2=Shah → Riya Shah.
  2. TEXTJOIN Mumbai, Pune, Nashik ", " सह → Mumbai, Pune, Nashik.
  3. Blank cell — TRUE असल्यास skip.

Vertical practice steps

  1. दोन लोकांचे First / Last.
  2. & ने join.
  3. City जोडा; CONCAT + em dash.
  4. तीन cities column मध्ये; TEXTJOIN.
  5. एक city blank सोडा; TRUE skip confirm.
  6. Formulas fill down.

Ravindra Bagale's Tip

जुना CONCATENATE अजून चालतो; नवीन sheets वर CONCAT किंवा TEXTJOIN. एका cell मध्ये line break साठी CHAR(10) + Wrap Text — address blocks साठी handy.

Practice task

  1. Customer First, Last, Area, City.
  2. Full name आणि Area, City columns.
  3. Mini invoice line साठी product names TEXTJOIN.
  4. & vs TEXTJOIN एका note मध्ये तुलना.

Learn it properly

Related guides: Remove duplicates · FILTER · IF

समजलं का? & आणि CONCAT pieces चिकटवतात; TEXTJOIN list delimiter सह चिकटवतो आणि blanks skip करू शकतो. आता FILTER dynamic array.

Frequently asked questions

& vs CONCAT?

Both join text. & is quick for two or three pieces. CONCAT handles many arguments cleanly.

What is TEXTJOIN?

Joins a range (or list) with a delimiter you choose, with an option to ignore empty cells.

Is CONCATENATE still OK?

Old function still works; prefer CONCAT or TEXTJOIN in new work.

Delimiter examples?

Space, comma-space, " | ", or CHAR(10) for a line break inside a cell (wrap text on).

Leading zeros lost?

Store codes as text before joining, or use TEXT with a format code.

Course lesson?

Chapter 3 — Joining text, CONCAT, TEXTJOIN and TEXT.