Shaqada beddelka^(Substitute) ee Microsoft Excel waxay ku beddeshaa qoraal gaar ah oo ku jira xargaha qoraalka oo leh qoraal kale. Hawsha Bedelku^(Replace) waxa ay beddeshaa qayb ka mid ah xargaha qoraalka iyada oo ku saleysan tirada xarfaha aad ku sheegtay xarfo qoraal oo ka duwan. Waxay beddeshaa dabeecadda lagu qeexay goobta. Tababarkan, waxaan ku sharixi doonaa sida loo isticmaalo Beddelka iyo sidoo kale shaqada Bedelka^(Replace) ee Excel .

Qaabka shaqada Beddelku^(Substitute) waa:

Substitute (text,old_text,new_text,[instance_ num])

Qaabka shaqada Beddelku^(Replace) waa:

Replace (old_text, start_num, num_chars, new_text)

Isku -dhafka Beddelka^(Substitute) iyo Bedelka Hawlaha^{(Replace Functions)}

Shaqada Beddelka

• Qoraal^(Text) : Qoraalka^(Text) ama unugga aad rabto inaad ku beddesho jilayaasha. loo baahan yahay
• Old_text : Qoraalka^(Text) aad rabto inaad bedesho. loo baahan yahay
• New_text : qoraalka aad rabto inaad ku bedesho old_text. loo baahan yahay
• Tusaalaha_^{(Instance_ num)} nambarka : Wuxuu qeexayaa qoraalkii hore ee aad rabto inaad ku badasho qoraalka_^(Text) cusub . ^(Text)Ikhtiyaar^(Optional) ah .

Beddel Shaqada

• Old_text : Qoraalka aad rabto inaad bedesho. loo baahan^(Required) yahay
• Start_num : booska jilaha aad rabto inaad ku bedesho old_text.
• Num_chars : Tirada xarfaha qoraalka hore ee aad rabto inaad ku badasho new_text.
• New_text : Qoraalka bedeli doona jilayaasha qoraalkii hore.

Sida loo isticmaalo shaqada bedelka^(Substitute) ee Excel

Fur Microsoft Excel .

Samee miis ama isticmaal miiska jira.

Casharradan, waxaan ku haynaa qoraalka ' hhans 1997 ' ee tiirka qoraalka; Waxaan rabnaa inaan ku bedelno ' h ' ka ' s '.

Guji^(Click) unugga meesha aad rabto inaad natiijada dhigto.

Ku qor Unugga = Substitute , ka dibna garabka.

Gudaha xarkaha nooca A3 , kani waa unugga ka kooban qoraalka^(Text) . Markaa komma

Kadibna ku qor Old_text , kaas oo ah " h ." Markaa komma

Kadib waxaan ku dari doonaa qoraalka cusub^(New_text) , kaas oo ah " s " sababtoo ah waxaan rabnaa inaan ku bedelno " h " oo leh " s ."

Waxaan ku dari doonaa tusaale_ nambar^{(Instance_ num)} , kaas oo qeexaya meesha qoraalka ah ee aan rabno inaan ku bedelno xarafka; ' h ' waa xarafka ugu horreeya, waxaanu gelin doonaa nambarka Tusaalaha ^{(Instance_ num)}mid^(one) ahaan .

Waa in ay ahaataa sidan: =SUBSTITUTE(A3,”h”,”s”,1 )

Kadib taabo furaha Gelida^(Enter) si aad u aragto natiijooyinka.

Waxaa jira laba hab oo kale oo loo isticmaalo shaqada Beddelka^(Substitute) .

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

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

Gudaha sanduuqa wada hadalka, qaybta Qaybta^(Category) , dhagsii falaarta hoos u dhacday oo dooro Qoraal^(Text) .

Kadib dooro shaqada bedelka^(Substitute) .

Wadahadalka Doodaha Shaqada^{(Function Arguments)} ayaa soo bixi doona.

• Ku qor A3 sanduuqa qoraalka qoraalka
• Ku qor " h " sanduuqa gelinta Old_text.
• Ku qor" s " sanduuqa gelinta cusub ee _text.
• Ku qor " 1 " sanduuqa gelida tusaale_Num.

Kadib taabo OK .

Habka labaad waa in la aado tab Formula oo guji Text in kooxda Library Function^{(Function Library)} .

Liiska hoos-u-dhaca qoraalka , guji ^(Text)Beddel^(Substitute) .

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

Habka waxaa lagu sharaxay habka koowaad ee sanduuqa wada hadalka doodaha Shaqada^{(Function Arguments)} .

Akhri^(Read) : Sida loo isticmaalo hawlaha Find iyo FindB ee Excel^{(How to use the Find and FindB functions in Excel)} .

Sida loo isticmaalo shaqada beddelka^(Replace) ee Excel

Guji^(Click) unugga meesha aad rabto inaad natiijada dhigto.

Nooca unugga =Replace ; ka dibna gunti.

Gudaha gunta, geli unugga halka uu Old_text yaalo^(Old_text) , kaas oo ah A3 . Markaa komma

Start_num -^(Start_num) ka , waxaanu gali doonaa nambarka Todoba^(Seven) sababtoo ah kani waa lambarka aan rabno inaan bedelno.

Num_chars -^(Num_chars) ka , waxaanu gali doonaa lambarka Saddexaad^(Three) sababtoo ah tani waa inta xaraf ee aan rabno inaan bedelno.

Qoraalka_cusub , waxaan gali doonaa " P ^(New_text)"^(P) sababtoo ah kani waa qoraalka aan ku bedeli doono seddexda xaraf.

Waa inay u ekaataa sidan; =REPLACE(A3,7,3, “P”).

Riix Gelida, waxaad arki doontaa natiijooyin.

Waxaa jira laba hab oo kale oo loo isticmaalo shaqada Bedelka^(Replace) .

Habka koowaad waa in aad tagto fx xagga sare ee xaashida shaqada ee bidixda.

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

Gudaha sanduuqa wada hadalka, qaybta Qaybta^(Category) , dhagsii falaarta hoos u dhacday oo dooro Qoraal^(Text) .

Dooro Bedel^(Replace) shaqada.

Wadahadalka Doodaha Shaqada^{(Function Arguments)} ayaa soo bixi doona.

• Ku qor A3 sanduuqa gelinta   Old_text
• Ku qor 7 sanduuqa  gelitaanka Start_num
• Ku qor 3 sanduuqa  gelida Num_chars .
• Ku qor " P " sanduuqa gelida New_text

Kadib taabo OK .

Habka labaad waa in la aado tab Formula ee kooxda ^{(Formula )}Library Function^{(Function Library)} ; dhagsii Qoraalka^(Text) .

Liiska hoos-u-dhaca Qoraalka , dooro ^(Text)Beddel^(Replace) .

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

Habka waxaa lagu sharaxay habka koowaad ee sanduuqa wada hadalka doodaha Shaqada^{(Function Arguments)} .

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

How to use Substitute and Replace Functions in Excel

The Substitute function in Microsoft Excel replaces a specific text in a text string with a different text. The Replace function replaces part of a text string based on the number of characters you specify with a different text string. It replaces the character specified by location. In this tutorial, we will explain how to use the Substitute as well as the Replace function in Excel.

The formula for the Substitute function is:

Substitute (text,old_text,new_text,[instance_ num])

The formula for the Replace function is:

Replace (old_text, start_num, num_chars, new_text)

Syntax of Substitute and Replace Functions

Substitute Function

• Text: The Text or cell in which you want to substitute characters. Required.
• Old_text: The Text you want to replace. Required
• New_text: the text you want to replace the old_text with. Required.
• Instance_ num: Specifies which old_Text you want to replace with the new_ Text. Optional.

Replace Function

• Old_text: The text you want to replace. Required.
• Start_num: The position of the character you want to replace in the old_text.
• Num_chars: The number of characters in old_ text you want to replace with new_text.
• New_text: The text that will replace the characters in the old_ text.

How to use the Substitute function in Excel

Open Microsoft Excel.

Create a table or use an existing table.

In this tutorial, we have the text ‘hhans 1997‘ in the text column; we want to substitute the’ h‘ with an ‘s.’

Click the cell where you want to place the result.

Type in the Cell = Substitute, then bracket.

Inside the bracket type A3, this is the cell that contains the Text. Then comma.

Then type the Old_text, which is “h.” Then comma.

Then we will add the New_text, which is “s” because we want to substitute the” h” with “s.”

We will add the Instance_ num, which specifies which location in the text we want to substitute the letter; the ‘h‘ is the first letter, we will input the Instance_ num as one.

It should be like this: =SUBSTITUTE(A3,”h”,”s”,1)

Then press the Enter key to see results.

There are two other methods to use the Substitute function.

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

An Insert Function dialog box will appear,

Inside the dialog box, in the Category section, click the drop-down arrow and select Text.

Then select Substitute function.

A Function Arguments dialog will pop up.

• Type A3 into the Text entry box.
• Type “h” into the Old_text entry box.
• Type “s” into the New _text entry box.
• Type “1” into the Instance_Num entry box.

Then press OK.

Method two is to go to the Formula tab and click Text in the Function Library group.

In the Text drop-down list, click Substitute.

A Function Arguments dialog box will appear.

The process is explained in method one for the Function Arguments dialog box.

Read: How to use the Find and FindB functions in Excel.

How to use the Replace function in Excel

Click the cell where you want to place the result.

In this cell type =Replace; then bracket.

Inside the bracket, input the cell where the Old_text is, which is A3. Then comma

For the Start_num, we will enter the number Seven because this is the character number we want to replace.

For the Num_chars, we will enter the number Three because this is how many characters we want to replace.

For the New_text, we will enter “P” because this is the text we will replace the three characters with.

It should look like this; =REPLACE(A3,7,3, “P”).

Press Enter, you will see results.

There are two other methods to use the Replace function.

Method one is to go to fx at the top of the worksheet on the left.

An Insert Function dialog box will appear.

Inside the dialog box, in the Category section, click the drop-down arrow and select Text.

Select Replace function.

A Function Arguments dialog will pop up.

• Type A3 into the  Old_text entry box.
• Type 7  into the Start_num entry box.
• Type 3  into the Num_chars entry box.
• Type “P” into the New_text entry box.

Then press OK.

Method two is to go to the Formula tab in the Function Library group; click Text.

In the Text drop-down list, select Replace.

A Function Arguments dialog box will appear.

The process is explained in method one for the Function Arguments dialog box.

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

Related posts

• Sida loo isticmaalo INT iyo Functions LCM gudaha Excel

• Sida loo isticmaalo EDATE iyo EOMONTH Functions gudaha Excel

• Sida loo geliyo oo loo xisaabiyo foomamka iyo shaqooyinka Excel

• Sida loo isticmaalo SUMIF iyo SUMIFS Functions gudaha Excel

• Sida loo isticmaalo MIN, Max, iyo AVERAGE Functions gudaha Excel

• Sida loo isticmaalo shaqada DGET gudaha Excel

• Sida loogu daro Trendline xaashida shaqada ee Microsoft Excel

• Sidee loo xisaabiyaa korodhka ama hoos u dhaca boqolkiiba ee Excel?

• Sida loo isticmaalo Find and FindB functional in Excel

• Microsoft Excel waxay isku dayaysaa inay soo ceshato macluumaadkaaga

• Sida loo isticmaalo shaqada Mode ee Excel

• Sida loo isticmaalo Muddada Dhaqaale Function gudaha Excel

• Sida loo isticmaalo Rept Function gudaha Excel

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

• Sida loo abuuro oo loo isticmaalo Koontaroolada Foomka gudaha Excel

• Casharka Microsoft Excel, ee Bilowga ah

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

• Khaladka Run-time 1004, Ma socodsiin karo Macro gudaha Excel

• Sida loo isticmaalo shaqada NETWORKDAYS gudaha Excel

• U beddelo CSV una beddelo Excel (XLS ama XLSX) adoo isticmaalaya khadka taliska ee Windows