Concatenate Formula Excel Hindi

Learn how to use the Concatenate formula in MS Excel in Hindi. The Concatenate formula in Excel can be used to join data in different cells into a single cell.
The Excel Guru has displayed 2 ways of using the Concatenate Formula in Excel
1) By entering the formula syntax = concatenate(text1, text2)
here the Guru has also instructed about adding a space a comma or a specific value in the final result.

2) By using the Fx insert formula feature of MS Excel.

Do provide your comment on…

31 thoughts on “Concatenate Formula Excel Hindi

  1. If i selct a row ,in which 100 names are there and i want to add upper qoutes and add comma and want to select all 100 names how can i do this.
    For eg. 'Recs', like this.and want all names change like this.
    What can i do.

  2. hello sir ap bht hi ache se samjhate hai or hmko smjh mai bhi ata hai
    sir ek request h apse jo bhi ap sikhate h jese ki apne concatenate k bare m btaya agr sir ap isi excel ko description m link de do to bht hi acha rahega jisse ki hmko asani se file mil jaye or practise krne m bhi asani ho..

  3. Sir, mere paas laptop ya desktop ki suvidha nahi hai. Waise to mujhe aapke har video's ya fir yeh maan lijiye ki aapke hi video's achhe lagte hain. Pr ek request thi ki iss wale video ko mobile mein dekhne ke karan main theek se seekh nahi paya. Yeh thoda screen size se chota laga mujhe. Sir next time plz thoda paas se camera lekr video banaye. Its a request to u sir.

Leave a Reply

Your email address will not be published. Required fields are marked *