Concatenate Formula in Excel Hindi

[@Being_Manish]

Amaing vdo bro...so simple n da way u explain is woww..

[@TeachToEach]

Thanks Manish

[@balance1772]

Sir you are my Hero.... I am your big fan

[@TeachToEach]

Thanks Mithun Ji

[@dipakshah3778]

Awesome bhai. Nice work!

[@manojmalhotra7052]

Very very nice video.... I like it...

[@lakhankushwah1338]

Very nice sir...thanks

[@TeachToEach]

Welcome

[@handsomeboy7194]

great work bhai......

[@MohdIrfan-du7zk]

Excellent. Thank you so much brother. Very helpful formula

[@prititiwari6897]

Thank you

[@sarojdurgablogs8951]

Very good bro

[@TeachToEach]

Thanks

[@maheshsahu425]

very nice sir..

[@TeachToEach]

Thanks Mahesh

[@ManpreetKaur-tp6im]

very meaningfull

[@TeachToEach]

Thanks Manpreet Ji for the comment.

[@anjaneyulukodam9961]

Good morning sir,

[@trickysportsbesttricks7383]

VERY NICE. It is so useful for us i cann't discript its

[@TeachToEach]

Thanks Ramesh ji for the commen.

[@sweta8650]

wow awesome...

[@TeachToEach]

Thanks for the comment Sweta.

[@Naveenkumar-fo1ns]

Thank you very much sir

[@TeachToEach]

Welcome naveen

[@kamleshsunny50]

Marvelous!

[@TeachToEach]

Thanks Kamlesh

[@azharshaikh4285]

very nice

[@TeachToEach]

Thanks Azhar

[@azharshaikh4285]

TeachToEach I received sheet it's veeeery useful sirji

[@tagedge]

if and istext will work if first name is number(not string/ not text) or both first and last name is number

[@rajujamadhar]

Nice one

[@TeachToEach]

Thanks Raj

[@abang1101]

Superb sir ji

[@TeachToEach]

Thanks Narendra

[@amatureexplorer]

Sir I want to make bold and underlined some part of the sentence using concatenate formula in MS Excel. What should I do?

[@TeachToEach]

Can't do when you are using concatenate formula

[@AmritSingh-ju6fv]

Sir ,
I have a question that if have two rows in first "name" and in another "time", when I use concatenate to combine then time comes into number , so how can I again convert that in time format in concatenate output

[@TeachToEach]

Thanks for asking this query.
You can use a TEXT Function for a date while concatenate text and date. So that you will a correct answer.
Will sure make a video to expain briefly.

[@Akhelsa47]

Wooooow

[@dhanishmehta]

Hello Sir....
Can u pls show me here the deconcatenate formula. ?
for eg
Mr ABC is in column A, now i want to separate Mr in one column and ABC in other column...
Would be of gr8 help.....

[@viralmasti734]

use text to column option

[@Dimpy_Sharma143]

Hello, Ashish sir,
I am Arun and i also like your videos.
I have an trouble,
Is any formula to add single space between first name last name string text. Example- Arunkumar this is a string text. I need like this Arun kumar.
Hope you understand my concern.

[@TeachToEach]

See excel also working on some criteria. But if you multiple name like this so how can u differentiate that first name end here n last name start from there. This is the issue in this question. No formula works here

[@pankajkandwal3699]

@@TeachToEach but if the name is in proper case without space....then is it possible ??????

[@atulrana9633]

Boss concatenate me 4- 5 columns add krne hai but jo cell blank ho uski jgh , ajaye kese higa

[@TeachToEach]

Atul Jo Blank hai uski Jagah kya ..... Pura Question likhiye please.

[@atulrana9633]

@@TeachToEach Sir maam 3 columns hai jisme first columns me address 1 hai 2nd me address2 hai 3rd me address 3 hai or ye 3 columns me bohot se logo ke address hai or mujhe sb ko ek hi columns me lana hai "," ke sath lekin agar kisi column ka 2nd ya 3rd blank hai to wo blank hi le jo concatnate krte wqt "," na le

[@ravipatel-be6fw]

Agar table me se koi date ka data dusari sheet me kese transfer kar sakate hai?? Or vo date ke table me ak se jayada data ho. To.

[@TeachToEach]

Please share your excel file so that i will share a proper solution your query is not clear. ID - [e-mail]

[@RajniSharma-kw3pv]

very nice vdo i like it [e-mail]

[@TheHanumanta]

How can I use the "proper case" formula after applying the "if,is text,concatenate" logic?

[@TeachToEach]

Use Proper before IF , means you start a formula with proper after that used your other formula

[@rohitgaba5741]

Please freeze karna btae column & row together
Thanks

[@TeachToEach]

Will make a video Rohit bro

[@reviewofficer-kuchbhirevie2529]

I want to write current date with dome text . =today ()"comment". Is it correct?

[@TeachToEach]

Sorry Sanjay but this is not the right way to combine a date with text. because when you combine text with date then date format automatically changes so that you must to use text function to give a format.
Correct way to write this formula is ="Today Date is"&" "&TEXT(TODAY(),"dd-mm-yyyy")

[@reviewofficer-kuchbhirevie2529]

Thanks for your reply 😊

[@MohdIrfan-du7zk]

Dear i want to learn Alpha beta gamma calculations

[@adpcalwar8343]

mst

[@TeachToEach]

Thanks Alwar

[@shwetasharma5128]

nice

[@TeachToEach]

Thanks Shweta for comment.

[@gopalsharma3618]

sir and kaisa legae

[@devendrarawat7123]

Sabse phle rawat or mai bhi rawat😂

[@TeachToEach]

Hahaah

[@shailendra83chauhan]

अगर कुछ सेल ब्लेंक है, और कुछ मैं लिखा है, तो ब्लेंक सेल को कैसे छोड़े

[@adityakundur]

Humko Adnav ki jagah name and Name ki jagah Adnav . Sikhna hai

[@TeachToEach]

What is Adnav?

[@badshaansarizv7860]

Wasimakhter

[@imranali-iy5wk]

send me

[@maheshsahu425]

very nice sir..

[@TeachToEach]

welcome

[@ranjantalks9657]

nice

[@TeachToEach]

Welcome Ranjan