Shaqada Hel^(Find) ee Microsoft Excel waxay u xisaabisaa xaraf kasta hal-byte ama laba-byte hal, iyadoon loo eegin goobta luqadda caadiga ah. Shaqada FindB waxay tirisaa xaraf kasta hal; waxa kaliya oo ay taageertaa xaraf kasta oo laba-byte ah sida laba marka aad awood u yeelatid tafatirka luqad taageeraya DBCS oo aad u dejiso luqadda caadiga ah. Tababarkan, waxaan ku sharixi doonaa sida loo isticmaalo Find iyo function FindB .

Qaabka loo helo^(Find) shaqada waa:

Find(find_text,within_text,[start_num])

Qaabka shaqada FindB waa:

FindB(find_text,within_text,[start_num])

Ereyga raadinta iyo FindB waa:

• Find_text : Qoraalka aad rabto inaad hesho. Waa loo baahan yahay.
• Inin_text^{(Within_text)} : Qoraalka ka kooban qoraalka aad rabto inaad hesho. Waa loo baahan yahay.
• Start_num : Ku sheeg dabeecadda lagu bilaabayo raadinta. Waa ikhtiyaari.

Sida loo isticmaalo Find function gudaha Excel

Tababarkan, waxaan rabnaa inaan helno dabeecadda ' Doofaar^(Pig) .'

Waxaan dooneynaa inaan gujino unugga meesha aan rabno inaan ka helno jilaha. Markaas ku qor =Find ; guntin.

Gudaha bracket-ka, waxaan ku qori doonaa " Doofaar^(Pig) ," oo ah qoraalka aan rabno inaan helno.

Kadibna ku dar comma oo ku qor A3 ama dhagsii unugga; kani waa unugga qoraalka ka kooban; ku dar comma.

Haddii aad dooratid inaad xirto xirmada ka dib ku dar A3 oo taabo Gelida^(Enter) , natiijadu waxay noqon doontaa siddeed sababtoo ah shaqada Find waxay ku tirin doontaa ' P ' gudaha " doofaarka^(pig) " sida dabeecadda siddeedaad.

Ka soo qaad in^(Suppose) aad doorato in aad ku darto hakad oo aad geliso Start_num^(Start_num) . Tababarkan, waxaan dooran doonaa inaan gelino lambarka afar iyo tobnaad^(Fourteenth) .

Natiijadu waxay ku soo baxday labaatan^(Twenty) .

Waxa jira laba hab oo kale oo loo isticmaalo hawsha Find .

Habka koowaad waa in la gujiyo Gelida Shaqada^{(Insert Function)} ( fx ).

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

Sanduuqa wada hadalka, dooro qaybta Qoraalka ^(Text).

Dooro shaqada Find , ka dibna taabo OK .

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

Sanduuqa wada hadalka doodaha Functions ee aagga ^{(Functions Argument)}Find_text , ku qor " doofaar^(pig) ."

Gudaha Inin_text^{(Within_text)} , ku qor A3.

Goobta Start_num , ku qor afar iyo toban^(Fourteen) , taas oo ah ikhtiyaari.

Guji OK _

Waxaad arki doontaa natiijada.

Habka labaad^{(Method two)} waa in xulashada kale ay tahay in la aado Formulas . Kooxda Maktabada Shaqada^{(Function Library)} , dooro Qoraal^(Text) . Liiska liiska hoos-u-hoosaadka ah, dooro Find .

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

Samee isla habka kor ku xusan.

Akhri^(Read) : Sida loo Helo loona Bedelo Calaamadaha Wildcard gudaha Excel .

Sida loo isticmaalo shaqada FindB ee Excel

Tababarkan, waxaanu ku tirin doonaa jilayaasha luuqad kale.

Guji^(Click) qolka aad rabto in natiijadu gasho tan =FINDB(“第" A3) . Start_num waa ikhtiyaar

Riix Gelida^(Enter) .

Natiijadu waxay noqonaysaa Saddex^(Three) .

Waxa lagu tiriyaa "第" sida jilaa labaad.

Waxaan rajeynayaa in tani ay caawineyso; haddii aad wax su'aalo ah qabtid, fadlan faallo ka bixi hoos.

How to use Find and FindB functions in Excel

The Find function in Microsoft Excel counts each character single-byte or double-byte as one, no matter the default language setting. The FindB function counts each character as one; it only supports each double-byte character as two when you enable editing a language supporting DBCS and setting it as the default language. In this tutorial, we will explain how to use the Find and the FindB function.

The formula for the Find function is:

Find(find_text,within_text,[start_num])

The formula for the FindB function is:

FindB(find_text,within_text,[start_num])

The syntax for Find and FindB are:

• Find_text: The text you want to find. It is required.
• Within_text: The text containing the text you want to find. It is required.
• Start_num: States the character at which to start the search. It is optional.

How to use the Find function In Excel

In this tutorial, we want to find the character of ‘Pig.’

We are going to click the cell where we want to find the character. Then type =Find; bracket.

Inside the bracket, we will type “Pig,” which is the text we want to find.

Then add a comma and type A3 or click the cell; this is the cell that contains the text; add a comma.

If you chose to close the bracket after add A3 and press Enter, the result of the character would be eight because the Find function will count ‘P’ in “pig” as the eighth character.

Suppose you choose to add a comma and enter the Start_num. In this tutorial, we will choose to enter the number Fourteenth.

The result came out to be Twenty.

There are two other methods to use the Find function.

Method one is to click Insert Function (fx).

An Insert Function dialog box will appear.

In the dialog box, select the category Text.

Select the function Find, then press OK.

A Function Arguments Dialog box will pop up.

In the Functions Argument dialog box in the Find_text area, type “pig.”

In the Within_text area, type A3.

In the Start_num area, type Fourteen, which is optional.

Click OK.

You will see the result.

Method two is to The other option is to go to Formulas. In the Function Library group, select Text. In the drop-down menu list, select Find.

A Function Arguments Dialog box will appear.

Do the same process above.

Read: How to Find and Replace Wildcard Characters in Excel.

How to use the FindB function in Excel

In this tutorial, we are going to count the characters in another language.

Click in the cell where you want the result to enter this =FINDB(“第” A3). Start_num is optional.

Press Enter.

The result would be Three.

It counted “第” as the second character.

I hope this helps; if you have questions, please comment below.

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 shaqada DGET gudaha Excel

• Sida loo isticmaalo shaqada HLOOKUP ee Microsoft Excel

• Sida loo qaboojiyo oo loo kala qaybiyo xaashida shaqada ee Excel

• Sida loo abuuro oo loo isticmaalo Koontaroolada Foomka gudaha Excel

• Sida loo bilaabo Word, Excel, PowerPoint, Outlook in Mode Safe

• Sida loo isticmaalo DCOUNT iyo DCOUNTA Function gudaha Excel

• Sida loogu daro Trendline xaashida shaqada ee Microsoft Excel

• Sida loogu isticmaalo DEC2Bin gudaha Excel si loogu beddelo nambarka jajab tobanle ee binary

• Microsoft Excel waxay isku dayaysaa inay soo ceshato macluumaadkaaga

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

• Sida loogu isticmaalo shaqada MID iyo MIDB gudaha Microsoft Excel

• Sida loo isticmaalo Muddada Dhaqaale Function gudaha Excel

• Sida loo abuuro Bracket tartanka gudaha Windows 11/10

• Sida loo isticmaalo shaqada ISODD ee Excel

• Sida loo beddelo midabka warqadda shaqada ee Excel