Gudaha Microsoft Excel , Hawlaha Sare^(Upper) iyo Hoose^(Lower) waa hawlaha qoraalka. Shaqada hoose ujeeddadeedu waa in qoraalka loo beddelo far yar^(lowercase) , shaqada sarena^(Upper) waxay u beddeshaa qoraalka far waaweyn^(uppercase) .

Erayga shaqada sare^(Upper) iyo hoose ^(Lower)_^(Syntax) _

Qaabka shaqada hoose waa HOOSE^(LOWER) (qoraal) halka sarena^(Upper) waa SARE^(UPPER) (qoraalka).

Hoose

Qoraal: Qoraalka aad rabto inaad u beddesho far-yar. Waa loo baahan yahay.

Sare

Qoraal: Qoraalka aad rabto inaad u beddesho far waaweyn. Waa loo baahan yahay.

Casharradan, waxaan ku sharixi doonaa sida loo isticmaalo shaqada hoose si loogu beddelo qoraalka far yar iyo shaqada sare^(Upper) oo loogu beddelo qoraalka far waaweyn.

Adeegso^{(Use Lower)} shaqada hoose si aad qoraalka ugu beddelato far yar oo Excel ah^(Excel)

Fur Excel

Ku qor^(Write) far waaweyn unugga ama unugyada.

Ku qor qolka aad rabto inaad natiijada dhigto, =LOWER(A2) .

A2   waa unugga ka kooban qoraalka aad rabto inaad u beddesho far-yar.

Riix^(Press) geli waxaad arki doontaa natiijada.

Si aad u hesho natiijooyinka kale, hoos u jiid gacanta buuxinta.

Waxaa jira laba hab oo kale oo loo isticmaalo shaqadan.

Habka koowaad waa inaad gujiso badhanka fx ee bidixda sare ee xaashida shaqada.

Sanduuqa wada hadalka shaqada Gelida ayaa soo bixi doona^{(Insert Function)} .

Gudaha sanduuqa wada hadalka ee ka dooro^{(Select a Category)} qaybta qaybta, ka dooro qoraalka^(Text) sanduuqa liiska.

Qeybta Xulashada Shaqada^{(Select a Function)} , ka dooro shaqada hoose^(Lower) sanduuqa liiska.

Markaa OK

Sanduuqa wada hadalka doodaha Shaqada^{(Function Arguments)} ayaa soo bixi doona.

Gudaha sanduuqa wada hadalka, geli A2 sanduuqa qoraalka^(Text) .

Markaa OK .

Habka labaad waa in la gujiyo Formulas tab oo dooro batoonka qoraalka ee kooxda ^(Text)Maktabadda Function^{(Function Library)} .

Ka dooro shaqada Lowe r liiska.

Sanduuqa wada hadalka doodaha Function^{(Function Arguments)} ayaa soo bixi doona.

Raac^(Follow) habka koowaad ee tillaabooyinka sanduuqa wada hadalka doodaha Shaqada^{(Function Arguments)} .

Adeegso^{(Use Upper)} shaqada sare si aad qoraalka ugu badasho far waaweyn oo Excel ah^(Excel)

Geli^(Enter) qoraalka far-yar ee unugga ama unugyada.

Ku qor unugga meesha aad rabto inaad natiijada dhigto, =UPPER(A2) .

A2   waa unugga ka kooban qoraalka aad rabto inaad u beddesho far waaweyn.

Riix^(Press) geli waxaad arki doontaa natiijada.

Si aad u hesho natiijooyinka kale, hoos u jiid gacanta buuxinta.

Waxaa jira laba hab oo loo isticmaalo shaqada sare.

Habka koowaad waa inaad gujiso badhanka fx ee bidixda sare ee xaashida shaqada.

Sanduuqa wada hadalka Gelida ayaa soo bixi doona^{(Insert Function)} .

Gudaha sanduuqa wada hadalka ee ka dooro^{(Select a Category)} qaybta qaybta, ka dooro qoraalka^(Text) sanduuqa liiska.

Xulo^{(Select a Function)} qaybta shaqada , ka dooro shaqada sare^(Upper) sanduuqa liiska.

Sanduuqa wada hadalka doodaha Shaqada^{(Function Arguments)} ayaa soo bixi doona.

Gudaha sanduuqa wada hadalka, geli A2 sanduuqa qoraalka^{(Text )} .

Kadib dhagsii OK .

Habka labaad waa in la gujiyo Formulas tab oo dooro batoonka qoraalka ee kooxda ^(Text)Maktabadda Function^{(Function Library)} .

Ka dooro shaqada sare^(Upper) liiska.

Sanduuqa wada hadalka doodaha Function^{(Function Arguments)} ayaa soo bixi doona.

Raac^(Follow) habka koowaad ee tillaabooyinka sanduuqa wada hadalka doodaha Shaqada^{(Function Arguments)} .

Waa kaas!

Hadda akhri^{(Now read)} : Sida loo isticmaalo shaqada IMPOWER ee Excel^{(How to use the IMPOWER function in Excel)} .

How to use the Lower and Upper function in Excel

In Microsoft Excel, Upper and Lower functions are Text functions. The Lower function’s purpose is to convert text into lowercase, and the Upper function converts text to uppercase.

The Syntax for Upper and Lower function

The formula for the Lower function is LOWER (text) and for Upper is UPPER (text).

Lower

Text: The text that you want to convert to lowercase. It is required.

Upper

Text: The text that you want to convert to uppercase. It is required.

In this tutorial, we will explain how to use the Lower function to convert text into lowercase and the Upper function to convert text to uppercase.

Use Lower function to convert text into lowercase in Excel

Open Excel.

Write uppercase text into the cell or cells.

Type into the cell where you want to place the result, =LOWER(A2).

A2  is the cell that contains the text you want to convert to lowercase.

Press enter you will see the result.

To get the other results, drag the fill handle down.

There are two other methods to use this function.

Method one is to click the fx button on the top left of the worksheet.

An Insert Function dialog box will pop up.

Inside the dialog box in the Select a Category section, select Text from the list box.

In the Select a Function section, choose the Lower function from the list box.

Then OK.

A Function Arguments dialog box will appear.

Inside the dialog box, enter A2 in the Text box.

Then OK.

Method two is to click the Formulas tab and select the Text button in the Function Library group.

Select the Lower function from the list.

A Function Arguments dialog box will pop up.

Follow method one for the steps for the Function Arguments dialog box.

Use Upper function to convert text into uppercase in Excel

Enter lowercase text into the cell or cells.

Type into the cell where you want to place the result, =UPPER(A2).

A2  is the cell that contains the text you want to convert to uppercase.

Press enter you will see the result.

To get the other results, drag the fill handle down.

There are two methods to use the upper function.

Method one is to click the fx button on the top left of the worksheet.

An Insert Function dialog box will appear.

Inside the dialog box in the Select a Category section, select Text from the list box.

In the Select a Function section, choose the Upper function from the list box.

A Function Arguments dialog box will appear.

Inside the dialog box, enter A2 in the Text box.

Then click OK.

Method two is to click the Formulas tab and select the Text button in the Function Library group.

Select the Upper function from the list.

A Function Arguments dialog box will pop up.

Follow method one for the steps for the Function Arguments dialog box.

That’s it!

Now read: How to use the IMPOWER function in Excel.

Related posts

• Sida loo isticmaalo Percentile.Exc function gudaha Excel

• Sida loo isticmaalo shaqada NETWORKDAYS gudaha Excel

• Sida loo tiriyo lambarka Haa ama Maya ee Excel

• Excel, Word ama PowerPoint ma bilaabi karaan markii ugu dambeysay

• Sida loo isticmaalo sifada Nooca Xogta tooska ah ee Excel

• Sida loo isticmaalo INT iyo Functions LCM gudaha Excel

• Sida waqti loogu daro ama loogu daro Microsoft Excel

• Sida loo beddelo midabka warqadda shaqada ee Excel

• Sida loo joojiyo ama loo damiyo Wadaagista Buuga Shaqada ee Excel

• Xisaabi leexashada caadiga ah iyo khaladka caadiga ah ee macnaha Excel

• Microsoft Excel waxay sababtaa isticmaalka CPU sare marka uu socdo Windows 10

• Sida loo geliyo shaxda firfircoon ee xaashida Excel

• Sidee looga saaraa Akhri kaliya dukumeenti Excel ah?

• Sida loo isticmaalo EDATE iyo EOMONTH Functions gudaha Excel

• Sida loo isticmaalo Rept Function gudaha Excel

• Sida loo abuuro Shaxda Radar gudaha Windows 11/10

• Sida loo isticmaalo shaqada COOSE ee Excel

• Sida loo geliyo oo loo xisaabiyo foomamka iyo shaqooyinka Excel

• Sida loo qoro, loo dhiso, loona isticmaalo shaqada VLOOKUP gudaha Excel

• Sida loogu daro Trendline xaashida shaqada ee Microsoft Excel