Hawlaha MID^(MID) iyo MIDB labaduba waa shaqooyinka qoraalka ee Microsoft Excel . MID waxay soo celisaa tiro gaar ah oo xarfo ah xarfo qoraal ah oo ka bilaabmaya booska aad sheegtay; iyadoo lagu salaynayo tirada xarfaha aad sheegtay. Shaqada MID waxay u xisaabisaa xaraf kasta hal-byte ama laba-byte hal, iyadoon loo eegayn luqadda caadiga ah.

Qaabka shaqada MID waa MID(text, start_num, num_chars). Shaqada MIDB waxay ka soo celisaa tiro gaar ah oo xarfo xarfo qoraal ah oo ka bilaabmaya booska aad sheegtay; iyadoo lagu saleynayo tirada bytes ee aad sheegtay. Qaabka shaqada MIDB waa MIDB(text,start_num, num_bytes).

Syntax ee shaqada MID

• Qoraal^(Text) : Xarig ka kooban jilayaasha aad rabto inaad soo saarto. Waa loo baahan yahay.
• Start_num : booska jilaha ugu horreeya ee aad rabto inaad soo saarto. Haddii Start_num uu ka weyn yahay dhererka qoraalka, MID waxay soo celin doontaa qoraal madhan. Haddii Start_num uu ka yar yahay hal, markaas MID waxay soo celin doontaa qiimaha qaladka # VALUE .
• Num_chars : Wuxuu aqoonsadaa tirada xarfaha aad rabto in MID ay ka soo noqoto qoraalka. Waa loo baahan yahay.

Erayga shaqada MIDB

• Qoraal^(Text) : Xarig ka kooban jilayaasha aad rabto inaad soo saarto. Waa loo baahan yahay.
• Start_num : booska jilaha ugu horreeya ee aad rabto inaad soo saarto. Haddii Start_num uu ka weyn yahay dhererka qoraalka, MIDB waxay soo celin doontaa qoraal madhan. Haddii Start_num uu ka yar yahay hal, markaas MIDB waxay soo celin doontaa qiimaha qaladka # QIIMAHA^(VALUE) .
• Num_Bytes: Wuxuu^{(Num_Bytes: )} aqoonsadaa tirada xarfaha aad rabto in MIDB ka soo noqoto qoraalka bytes.

Sida loo isticmaalo shaqada MID ee Excel

Fur Microsoft Excel.

Isticmaal^(Use) miiska jira ama samee mid.

Gudaha qolka aad rabto inaad dhigto nooca natiijada =MID(A3,4,2) .

A3 waa xadhig ka kooban jilayaasha aad rabto inaad soo saarto.

4 waa meesha ugu horeysa ee aad rabto inaad soo saarto.

2 waa tirada xarfaha aad rabto in MID ay ka soo noqoto qoraalka.

Riix Gelida^{(Enter )} kiiboodhka si aad u aragto natiijada.

Haddii aad hoos u jiiddo gacanta buuxinta, waxaad arki kartaa natiijooyinka kale, oo waxaad bedeli kartaa Start_num iyo Num_chars haddii la rabo.

Waxaa jira laba hab oo kale oo loo isticmaalo shaqada MID .

Habka koowaad waa inaad gujiso badhanka fx ee bidix ee sare ee xaashida xaashida ee Excel .

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

Qeybta ka dooro^{(Select a Category)} qaybta, dhagsii qoraalka^(Text) sanduuqa liiska.

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

Kadib dhagsii OK .

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

Sanduuqa wada hadalka ee qaybta qoraalka^(Text) , geli sanduuqa A3 .

Qaybta Start_num , geli sanduuqa 4.

Qaybta Num_chars , geli sanduuqa 2.

Markaa OK .

Habka labaad waa inaad gujiso Formulas tab.

Kooxda Maktabada Shaqada^{(Function Library)} , dhagsii Qoraalka^(Text) .

Liiska hoos-u-dhaca, dhagsii MID .

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

Raac tillaabooyinka doodaha Hawlaha^{(Functions Arguments)} habka koowaad.

Akhri^(Read) : Sida loo sameeyo Shaxda Isku-dhafka ah ee Excel^{(How to create a Combination Chart in Excel)} .

Sida loo isticmaalo MIDB function in Excel

Geli^(Enter) qolka aad rabto inaad geliso natiijada =MIDB(A3,4,5) .

Waxaad ogaan doontaa in shaqada MIDB ay ku siin doonto isla natiijada shaqada MID .

Hawsha MIDB waxa ay ku tiriyaa laba jibbaar kasta oo laba-byte ah; haddii aad awood u yeelatid tafatirka luqadda taageera DBCS oo aad u dejiso luqadda caadiga ah.

Luuqadda taageerta DBCS waxa ku jira Jabbaan, Shiinaha, iyo Kuuriyaan^(Korean) .

Sidaa darteed, haddii uusan jirin luqad taageerta DBCS , MIDB waxay tirisaa xaraf kasta sida shaqada MID .

Waxaan rajeyneynaa in casharkan uu kaa caawiyo inaad fahamto sida loo isticmaalo shaqada MID iyo MIDB gudaha Excel .

How to use the MID and MIDB function in Microsoft Excel

MID and MIDB functions are both text functions in Microsoft Excel. MID returns a specific number of characters from a text string starting at the position you specify; based on the number of characters you specify. The MID function counts each character single-byte or double-byte as one, no matter the default language.

The formula for the MID function is MID(text, start_num, num_chars). The MIDB function returns a specific number of characters from a text string starting at the position you specify; based on the number of bytes you specify. The formula for the MIDB function is MIDB(text,start_num, num_bytes).

The Syntax for the MID function

• Text: The string containing the characters you want to extract. It is required.
• Start_num: The position of the first character you want to extract. If the Start_num is greater than the length of text, MID will return an empty text. If the Start_num is less than one, then the MID will return the error value #VALUE.
• Num_chars:  Identifies the number of characters you want MID to return from the text. It is required.

The Syntax for the MIDB function

• Text: The string containing the characters you want to extract. It is required.
• Start_num: The position of the first character you want to extract. If the Start_num is greater than the length of text, MIDB will return an empty text. If the Start_num is less than one, then the MIDB will return the error value #VALUE.
• Num_Bytes: Identifies the number of characters you want MIDB to return from the text in bytes.

How to use the MID function in Excel

Open Microsoft Excel.

Use an existing table or create one.

In the cell where you want to place the result type =MID(A3,4,2).

A3 is the string containing the characters you want to extract.

4 is the position of the first character you want to extract.

2 is the number of characters you want MID to return from the text.

Press Enter on the keyboard to see the result.

If you drag the fill handle down, you can see the other results, and you can change the Start_num and the Num_chars if desired.

There are two other methods to use the MID function.

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

An Insert Function dialog box will pop up.

In the Select a Category section, click Text from the list box.

In the Select a Function section, select the MID  function from the list box.

Then click OK.

A Functions Arguments dialog box will pop up.

In the dialog box in the Text section, enter into its box A3.

In the Start_num section, enter into its box 4.

In the Num_chars section, enter into its box 2.

Then OK.

Method two is to click the Formulas tab.

In the Function Library group, click Text.

In the drop-down list, click MID.

A Functions Arguments dialog box will appear.

Follow steps of the Functions Arguments in method one.

Read: How to create a Combination Chart in Excel.

How to use the MIDB functionin Excel

Enter into the cell where you want to enter the result =MIDB(A3,4,5).

You will notice that the MIDB function will give you the same result as the MID function.

The MIDB function will only count each double-byte character by two;  if you enable the editing of a language that supports DBCS and set it as the default language.

The language that supports DBCS includes Japanese, Chinese, and Korean.

Therefore, if no language supports DBCS, MIDB will count each character like the MID function.

We hope this tutorial helps you understand how to use the MID and MIDB function in Excel.

Related posts

• Sida loo isticmaalo shaqada HLOOKUP ee Microsoft Excel

• Sida looga soo saaro magacyada domain URL-yada Microsoft Excel

• Microsoft Excel waxay isku dayaysaa inay soo ceshato macluumaadkaaga

• Sida loogu daro Trendline xaashida shaqada ee Microsoft Excel

• Sida waqti loogu daro ama loogu daro Microsoft Excel

• Sideen u hagaajin karaa Runtime Error 1004 gudaha Microsoft Excel?

• Sida loo sameeyo sanduuqa sanduuqa Microsoft Excel

• Sida loo isticmaalo sifada Nooca Xogta tooska ah ee Excel

• Sida loo qaboojiyo safafka iyo tiirarka gudaha Excel

• Casharka Microsoft Excel, ee Bilowga ah

• Talooyin iyo tabaha Microsoft Excel ee bilowga ah

• Sida loo Quful Unugyada Microsoft Excel

• Sida loo isticmaalo shaqada MATCH Microsoft Excel

• Hagaaji qaladka Excel stdole32.tlb gudaha Windows 10

• Sida looga saaro erayga sirta ah ee Excel File

• Dib u eegis buug - Microsoft Excel 2010 Talaabo Talaabo ah

• Google Sheets vs Microsoft Excel - Waa maxay faraqa u dhexeeya?

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

• Sida foormulada loogu qariyo xaashiyaha Microsoft Excel

• Sida loo abuuro Gantt Charts gudaha Microsoft Excel