Advance Excel Me Concatenate Formula Kaise Lagaye

Hello friends, advance excel me concatenate formula ka use kaise karte hai, aur isse kaha par lagaya jata hai, aaj me iss excel tutorial ke madhyam se aapko batane ja raha hu, agar dusre sabdo me kaha jaye to concatenate ko “combine” ya “ek sath jodna” bhi keh sakte hai aur iss formula ka use excel worksheet ki do alag cells ke data ko ek cell me merge karne ke liye kiya jata hai.

Concatenate Formula Kaha Lagaya Jata Hai

Agar hume do jagah ke data ko ek jagah par jodna hai to excel me ye concatenate formula lagaya jata hai, for example first aur second column ke names ko kisi dusre column me ye formula lagakar ek sath mila sakte hai.

Advance Excel Me Concatenate Formula Kaise Lagaye

Excel worksheet me do alag cells ke data ko merge karna koi mushkil kaam nahi hai, aap chahe to manually dono cells ke data ko ek sath merge kar sakte hai, but jab humari worksheet me do columns me ek badi list ho to usko manually merge karna kafi mushkil ho jata hai, lekin agar aap concatenate formula ka use karte hai to dono columns ke data ko seconds me ek columns me merge kar sakte hai. to chaliye aapka jyada time na lete huye step by steps jaante hai ki advance excel me concatenate formula kaise lagate hai.

 

Step 1

Sabse pehle excel ki ek sheet open kare.

6

Ab do alag column me name daliye, jaise ki image me diya gaya hai pehle column me ramesh aur dusre column me singh.

 

 

Step 2

Ab aako name ke aage wale column me concatenate formula lagana hai.

 

8

Ab niche diya formula agle column me dale, aap kisi bhi column me formula dal sakte hai.

=concatenate(a3,” “,b3)

 

Step 3

Ab aap dekh sakte hai ki full name ki field me dono cells ka data ek sath merge ho gaya hai.

9

 

Lijiye concatenate formula ka use kaise karte hai ab aap jaan gaye hai, aur isi tarah aap badi se badi list ko bhi ek sath concatenate formula lagakar ek sath jod kar sakte hai.

 

Ye Post Bhi Padhe

??Advance Excel Related Jankari Ke Liye Yaha Click Kare

??Blogger Se Related Post Padhe

??Facebook Ke Bare Me Jane

??Youtube Se Related Post Padhe

??Twitter Se Related Post Padhe

??Blog Ke Liye Page Kaise Banaye

??Google Ke Bare Me Jane

 

Dosto aapko advance excel me concatenate formula se related ye post kaisi lagi apne comment ke dwara hume jarur bataye, aur kahi koi problem ho aap apne saval bhi puch sakte hai, iske sath hi iss post ko apne social networking sites par share karna bilkul na bhule.

Ramesh Singh

Hello Dosto ! Mera Naam Ramesh Singh Hai. Main Ek Passionate Blogger Hun. Ye Website Maine Banai Hai. Is Website Par Main Longo Ko Hindi Me Jankari Deta Hun Aur Unki Help Karta Hun. Read More

Leave a Reply

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