Za'a iya amfani da aikin SUBSTITUTE don maye gurbin kalmomi, kalmomi, ko haruffa tare da sababbin bayanai.
Lura: Sakamakon aikin dole ne ya bayyana a wuri daban daban fiye da rubutu na ainihi.
Amfani don aikin sun haɗa da:
- Ana cire takardun da ba a buga ba daga bayanan da aka shigo;
- Sauya harafin da ba'a so ba tare da wurare;
- Samar da iri-iri daban-daban na wannan takarda .
01 na 04
Sauya Tsohon Alkawari don Sabon
Ƙarƙashin Magana da Magana akan Sauya Ƙarfin
Haɗin aikin yana nufin layout na aikin kuma ya haɗa da sunan aikin, shafuka, da muhawara .
Hadawa don aikin SUBSTITUTE shine:
= SUBSTITUTE (Rubutu, Old_text, New_text, Instance_num)
Magana akan aikin shine:
Rubutu - (buƙatar) bayanai dauke da rubutun da za a maye gurbin. Wannan hujja zata iya ƙunsar
- ainihin bayanan da aka rufe a alamomi - jere biyu a cikin hoto a sama;
- tantancewar tantanin halitta game da wuri na bayanan rubutu a cikin takardun aiki - jere uku a sama;
Old_text - (da ake buƙata) an maye gurbin rubutu.
New_text - (buƙatar) rubutu da zai maye gurbin Old_text .
Instance_num - (na zaɓi) lamba
- Idan an cire shi, an maye gurbin Old_text tare da New_text .
- Idan an haɗa, kawai misali na Old_text kayyade - kamar na farko ko na uku lokuta - an maye gurbin - layuka biyar da shida a sama.
02 na 04
Sensitivity Case
Ƙididdigar aikin SUBSTITUTE shine ƙwaƙwalwar sharaɗi, wanda ke nufin idan bayanan da aka shigar don ka'idar Old_text ba su da irin wannan yanayin a matsayin bayanai a cikin maganganun maganganu na rubutu , babu maye gurbi.
Alal misali, a cikin jere hudu daga cikin hoton da ke sama, aikin na tallace tallace tallace-tallace (A4) kamar bambanta daga tallace-tallace (Tsohon Alkawari ) kuma, sabili da haka, baya musanya kudin shiga a matsayin New_text .
03 na 04
Shigar da Ayyukan Gyara
Kodayake yana yiwuwa a rubuta dukkan tsari kamar
= SUBSTITUTE (A3, "Tallace-tallace", "Kudaden Gari")
da hannu a cikin wani saitunan aiki, wani zaɓi shine don amfani da maganganun maganganun - kamar yadda aka tsara a cikin matakan da ke ƙasa - don shigar da aikin da jayayya a cikin tantanin halitta irin su B3.
Amfani da amfani da maganganun maganganu shine Excel yana kula da raba kowace gardama tare da takaddama kuma yana rufe tsohon da sabbin bayanan rubutu a alamomi.
- Danna kan tantanin halitta B3 - don sa shi tantanin halitta mai aiki
- Danna maɓallin Formulas na shafin rubutun
- Latsa gunkin rubutu a kan rubutun don buɗe jerin rubutun ayyukan Rubutun
- Danna kan SUBSTITUTE a jerin don kawo wannan maganganun maganganun
- A cikin akwatin maganganu, danna kan Rubutun rubutu
- Danna kan salula A3 don shigar da wannan tantanin halitta a cikin akwatin maganganu
- Danna ma'anar Old_text a cikin akwatin maganganu
- Nauyin tallace-tallace , wanda shine rubutun da muke son maye gurbin - babu buƙatar ɗaukar rubutun a alamomi;
- Danna maɓallin New_text a cikin akwatin maganganu
- Rubuta Riba , kamar yadda aka sauya rubutun;
- An bar jigilar ta cikin layi - tun da akwai alamar kalma guda ɗaya a cikin salula A3;
- Danna Ya yi don kammala aikin kuma rufe akwatin maganganu;
- Rubutun Rahoton Rubutun ya kamata ya bayyana a cell B3;
- Lokacin da ka danna kan salula B3 da cikakken aikin
= SUBSTITUTE (A3, "Tallace-tallace", "Kudaden Gari")
ya bayyana a cikin maɓallin tsari a sama da takardun aiki
04 04
Sauya vs. Sauya
SABARI DA YA KASA YI KASA DA KASA KASA KASA KASA KASA KASA KUMA KASA KASA YA YI YA YI YA YI YA YI YA YI YA YI YA YI YA KAYA YA YI YA YI YA YI YA KAYA YA KAYA YA YA KAYA YA YA YA YA KAYA YA YA YA KAYA YA KAYA