Microsoft Excel main text ko lower ya upper case main kaise krain

Microsoft Excel main text ko lower ya upper case main kaise krain

Microsoft Excel main text ko lower ya upper case main kaise krain: Dosto aaj ham aapko batane ja rahe hain Microsoft Excel ke aise feature ke baare mein jis ki wajah se aksar hame bahut pareshaani hoti hai, aksar karke hame zaroorat hoti hai ke excel sheet main hame kisi text ko lower case main karna hota hai ya upper case main karna hota hai to generally hame uske function ke baare main zyada jaankaari nahi hoti iss wajah se ya to ham uss text ko Microsoft word main le jakar lower ya upper case main kare aur ya fir kabhi kabhi ye problem hoti hai ke ham uss column ya row ko word main le jakar ye kam nahi kar pate hain.

To dosto ham aap ko aaj Microsoft Excel ke uss function ke baare main batane ja rahe hain ki kaise ap excel sheet main text ko lower ya upper case main kar saktey hain.




Microsoft Excel main text ko lower case main kaise krain

Dosto sabse pehle ham aapko batayenge ki Microsoft excel main agar kisi text ko lower case main karna hai to kaise karenge uske liye sabse pehle aapko excel sheet main jis coloumn main ya jis row main aapko text ko lower case main karna hai usmain ek formula lagaya jata hai.

Example ke liye main aap ko batane ja raha hu ki agar hame kisi cell main text ko lower case main karna ho to kaise karenge;

Microsoft Excel main text ko lower ya upper case main kaise krain




Jaisa ki ap ooper wali screen main dekh saktey hain ki aap jaise hee Formula wale tab ke andar text wale tab ko jab click karenge to jo drop down khula hai usmain aap 2 no. wale gole main jisme lower likha hai usko click karne se pehle aap kisi blank cell main apne cursor ko rakhey uske baad uss cell main =LOWER() likha hua aa jayega uske baad aap ko jo bhi cell ke  text ko lower case main convert karna hai usmain cell ka no. yani ke B2 likhna hai – =LOWER(B2) likhenge aur enter maar denge to text lower case main aa jayega jaiseki aap ooper wali screen main dekh rahe hain hamne B2 cell jismain Company Name likha hai wo agle cell main =LOWER(B2) wale cell main lower case main ho jayega.

Read This Also : Excel main kuchh kaise dhhonde ya find kare aur replace kare

Read This Also : Excel sheet main duplicate rows ya entry kaise delete karain

Read This Also : 15 best new online business ideas turant paisa kamane ke

Read This Also : Top 5 Rastey Paisawala Ya Jaldi Rich Banane Ke

Read This Also : Top 20 best online survey websites ghar baithe rupiya paisa kamane ke liye

Microsoft Excel main text ko lower case main kaise krain

Jaise ki aap ooper wali screen main dekh saktey hain text lower case main ho gaya hai. Agar aap chahtey hain ki coloumn B ke saare cell lower case main karna hai to aapko bas itna karna hai ki jaisa ki neeche wali screen main dikhayee de raha hai excel sheet ke cell ke kone main jaisa ki + ka sign ban raha hai waise hee jab ban jaye to apne mouse ka button dabakar usko bina chhode huye neeche tak kheechkar le jaye jaha tak ke aapko text ko lower case main karna hai.

Microsoft Excel main text ko lower case main kaise krain

Microsoft Excel main text ko upper case main kaise krain

Dosto sam yahi formula aapko  text ko Upper Case main karne ke liye karna hota hai. bas aapko ye karna hai;

Microsoft Excel main text ko Upper case main kaise krain




Jaisa ke same ooper jo hamne lower case ke baare main bataya hai theek waise hee karna hai aur aapka text upper case main ho jayega.

Microsoft Excel main text ko Upper case main kaise krain 2

To dosto main ummeed karta hu ke aap logo ko samajh aa gaya hoga ki Microsoft Excel main text ko lower ya upper case main kaise krain.

Yadi aapko hamara ye post Microsoft Excel main text ko lower ya upper case main kaise krain pasand aaya ho to aap hame subscribe bhi kar saktey hain.

Agar ap ko koi bhi cheez samajh nahi ayi ho to hame comment box main likh kar apne problem ya sawaal likh kar bhej saktey hain.

Read This Also : Top 3 tarike online writing karke paisa kamane ke

Read This Also : Online ads dekhkar aur padhkar rupaya paisa kaise kamaye hindi main jaaney

Read This Also : 20 business ideas kam budget walo ke liye janiye hindi main

Read This Also : Online internet se bahut Rupay Paise kese kamay

Read This Also : SMARTPHONE SE PAISE KAISE KAMA SAKTEY HAIN HINDI ME JANIYE

Read This Also : FREE MAIN APNI WEBSITE YA BLOG KAISE BANAYE

Thanks ……. Dhanyavaad…….!!!!!

4 thoughts on “Microsoft Excel main text ko lower ya upper case main kaise krain

  • 22/08/2016 at 12:23 PM
    Permalink

    MUJHE MERI EXCEL ME FARMULLA SETTING SAHI KRNI HAI FUNCATION SAHI KAAM NHI KR RHE HELP ME (EXAMPLE. JIASE AUTO SAM FUNCTION SAHI TAREH SE KAAM NHI KRA

    Reply
    • 23/08/2016 at 12:20 AM
      Permalink

      Aahil khan sahab jaha tak aapke question se main samajh pa ra hu to mujhe aisa lagta hai ke aap jis cell main formula laga rahe hain uski shuruvaat main aap = (Equal ka sign ) shayad lagana bhhool rahe hai.

      Ya agar aap auto sum function menu main Formula wale tab ke andar jakar auto sum ka buttonclick karnge to us coloumn ka sum ho jayega aapko bas auto sum part click karna hai aur fir enter marna hai aapki problem solve ho jayegi.

      Ummeed karta hu ke isse aapki samasya ka samadhhan ho jayega…

      Shukriya……..

      Reply
  • 22/10/2016 at 2:23 PM
    Permalink

    Hi sir,
    Mujhe Excel Me Reconciliation Ke Baree Me Bata Sakte he..

    Reply

Leave a Reply

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