Ntchito Excel SUBSTITUTE

Ntchito SUBSTITUTE ingagwiritsidwe ntchito m'malo mwa mawu, malemba, kapena maina omwe alipo omwe ali ndi deta yatsopano.

Zindikirani: Zotsatira za ntchitoyi ziyenera kuwoneka m'malo osiyana ndizolemba zoyambirira.

Zogwiritsira ntchitoyi zikuphatikizapo:

• Kuchotsa malemba osasindikiza kuchokera ku deta yoitanitsidwa;
• Kusintha malemba osafunika ndi malo;
• Kupanga zosiyana zofanana pa tsamba limodzi .

01 a 04

Kusintha Zakale Zatsopano

Syntax ndi Mpikisano wa Ntchito Yopereka Mpata

Syntax ya ntchito imatanthawuza momwe ntchitoyo ikuyendera ndipo imaphatikizapo dzina la ntchito, mabaki, ndi zifukwa .

Chidule cha ntchito SUBSTITUTE ndi:

= SUBSTITUTE (Malembo, Old_text, New_text, Instance_num)

Zokambirana za ntchitoyi ndi izi:

Malemba - (oyenerera) deta yomwe ili ndi malemba omwe angasinthidwe. Mtsutso uwu ukhoza kukhala nawo

• deta yeniyeni yomwe ili mkati mwa zizindikiro zotsatsa - mzere wachiwiri mu chithunzi pamwambapa;
• selo lotanthauzira za malo a deta zomwe zili pamsewu wa ntchito - mzere watatu pamwambapa;

Old_text - (yofunika) malemba kuti m'malo.

Zatsopano_zolemba - (zofunikira) malemba omwe adzasintha Old_text .

Phunziro_num - (zosankha) nambala

• Ngati sanatuluke, chochitika chilichonse cha Old_text chimasinthidwa ndi New_text .
• Ngati ziphatikizidwa, chochitika cha Old_text chofotokozedwa - monga zochitika zoyamba kapena zitatu - zimalowetsedwa - mizere isanu ndi sikisi pamwambapa.

02 a 04

Kusamala kwa Mlandu

Zokambirana za SUBSTITUTE zimakhala zovuta, zomwe zikutanthauza ngati deta inalowa mu Old_text mkangano alibe chiwerengero chomwecho monga chiwerengero cha Text argument cell, palibe kusintha komwe kumachitika.

Mwachitsanzo, mu mzere wina wa chithunzi pamwambapa, malingaliro ogwira ntchito Malonda (selo A4) ndi osiyana ndi malonda (Old_text argument ) ndipo, kotero, samalowetsa Misonkho monga New_text .

03 a 04

Kulowa Ntchito Yoperewera

Ngakhale kuti n'zotheka kufalitsa mawonekedwe onse monga

= SUBSTITUTE (A3, "Sales", "Revenue")

mwapadera mu selo lopangira, gawo lina ndilo kugwiritsa ntchito bokosi lazolowetsa ntchito - monga momwe tafotokozera m'magulu otsatirawa - kulowa ntchito ndi zifukwa zake mu selo monga B3.

Ubwino wogwiritsira ntchito bokosilo ndikuti Excel imasamalira kulekanitsa mndandanda uliwonse ndi ndondomeko ndipo imatumiza deta yakale ndi yatsopano pamabuku a quotation.

1. Dinani pa selo B3 - kuti mupange selo yogwira ntchito
2. Dinani pa Fomu tab ya menyu yowonjezera
3. Dinani pazithunzi zalemba pa leboni kuti mutsegule Malemba amagwira ntchito
4. Dinani pa SUBSTITUTE mndandanda kuti mubweretse bokosi la bokosi la ntchitoyi
5. Mu bokosi la bokosi, dinani palemba mzere
6. Dinani pa selo A3 kuti mulowetse selo ili mu bokosi la bokosi
7. Dinani ku Old_text mzere mu bokosi la bokosi
8. Zolemba Zamitundu , ndizolemba zomwe tikufuna kuzilemba - palibe chifukwa choyikapo malemba mu zizindikiro za quotation;
9. Dinani ku New_text mzere mu bokosi la bokosi
10. Mtundu Wopezera , monga mawu oti alowe m'malo ;;
11. Chigwirizano cha Msonkhano chimasiyidwa chopanda kanthu - popeza pali chitsanzo chimodzi cha mawu akuti Sales mu selo A3;
12. Dinani OK kuti mutsirize ntchitoyi ndi kutseka bokosi la dialog;
13. Mauthenga Revenue Report ayenera kupezeka mu selo B3;
14. Mukasindikiza pa selo B3 ntchito yonse
    = SUBSTITUTE (A3, "Sales", "Revenue")
    imapezeka mu bar lamuzula pamwamba pa tsamba

04 a 04

Wotsutsa

SUBSTITUTE imasiyana ndi REPLACE ntchito yomwe imagwiritsidwa ntchito kusinthanitsa malemba ena pamalo alionse mu deta yosankhidwa pamene REPLACE imagwiritsiridwa ntchito m'malo mwa malemba onse omwe amapezeka pamalo enaake mu deta.