Hanyar 1: Yin Amfani da Kayan Aiki ta atomatik
Excel yana da kayan aiki na atomatik da aka tsara don raba rubutu cikin ginshiƙai. Ba ya yin aiki ta atomatik, saboda haka dole ne a yi duk da hannu, zaɓi kewayon bayanan da aka sarrafa. Koyaya, saiti shine mafi sauƙin sauƙi da sauri a cikin aiwatarwa.
- Tare da maɓallin linzamin kwamfuta na hagu, zaɓi duk sel wanda rubutun da kake son rarrabawa kan ginshiƙai.
- Bayan haka, je zuwa shafin "bayanai" kuma danna "Rubutun zuwa maɓallin".
- Window "shafin rubutu na" na "yana bayyana, wanda kake son zaɓar tsarin bayanai" tare da masu rabawa ". Mai rarrabawa mafi yawan lokuta yana yin sarari, amma idan wannan alama ce ta dabam, zaku buƙaci tantance shi a mataki na gaba.
- Tick Siffan alamar bincika ko kuma shigar da shi, sannan karanta sakamakon farko a cikin taga a ƙasa.
- A mataki na ƙarshe, zaku iya tantance sabon tsarin zane da kuma wurin da dole ne a sanya su. Da zarar an gama saitin, danna "Gama" don amfani da duk canje-canje.
- Komawa tebur kuma ka tabbata cewa rabuwa ya wuce cikin nasara.
Daga wannan koyarwar, zamu iya yanke hukuncin cewa amfani da irin wannan kayan aiki yana da kyau a cikin waɗancan yanayi da dole ne a yi sau ɗaya kawai, yana nuna kowace kalma sabon shafi. Koyaya, idan ana gabatar da sabon bayanai a cikin tebur, koyaushe don raba su wannan hanyar ba ta dace ba, don haka a irin waɗannan halaye muna ba da shawarar sanin kanku da wannan hanyar.
Hanyar 2: ƙirƙirar rubutun raba rubutu
Areo Excel, zaka iya ƙirƙirar tsari mai rikitarwa na ɗan adam wanda zai ba ka damar lissafin matsayin kalmomin a cikin sel, sami gibba kuma ya raba kowane ginshiƙai daban. A matsayin misali, zamu ɗauki sel wanda ya ƙunshi kalmomi uku da aka raba ta sarari. Ga kowane ɗayansu, zai ɗauki nasu tsari, saboda haka, muna rarraba hanyar zuwa matakai uku.Mataki na 1: rabuwa da kalmar farko
Tsarin kalma na farko shine mafi sauki, tunda dole ne a cire shi kawai daga wannan rata don tantance matsayin daidai. Yi la'akari da kowane mataki na halittarsa, don cikakken hoto wanda aka kirkira shine dalilin da yasa ake buƙatar wasu lissafin.
- Don dacewa, ƙirƙirar sabbin abubuwa uku tare da sa hannu a inda za mu ƙara rubutu daban. Kuna iya yin daidai ko tsallake wannan lokacin.
- Select sel inda kake son sanya kalmar farko, kuma rubuta wa formula = kasa da (.
- Bayan haka, latsa maɓallin "Zaɓin na muhawara", don haka yana motsawa cikin taga gyara mai hoto na dabara.
- Kamar yadda matanin muhawara, saka tantanin halitta tare da rubutu ta danna kan shi tare da maɓallin linzamin kwamfuta na hagu akan tebur.
- Yawan alamomi zuwa sarari ko wani mai rarrabawa dole ne su lissafta, amma da hannu ba za mu yi wannan ba, amma za mu yi amfani da wani tsari - bincika ().
- Da zaran ka rubuta shi a cikin irin wannan tsari, zai bayyana a matanin tantanin a saman kuma zai zama alama mai ƙarfin hali. Danna shi don saurin canzawa zuwa muhawara ta wannan aikin.
- A cikin filin "Skelon" kawai sanya sarari ko mai raba shi da amfani saboda zai taimaka muku fahimtar inda kalmar ta ƙare. A cikin "rubutu_-bincike" Saka da sel guda ana sarrafa shi.
- Latsa aikin farko don komawa gare shi, kuma ƙara a ƙarshen gardamarin na biyu -1. Wannan ya zama dole domin tsari na bincike don yin la'akari ba sarari da ake so ba, amma alamar a gare ta. Kamar yadda za a iya gani a allon allo mai zuwa, ana nuna sakamakon ba tare da wani sarari ba, wanda ke nufin cewa an yi tattarawa daidai.
- Rufe edita na aiki kuma tabbatar cewa kalmar an nuna daidai a cikin sabon sel.
- Riƙe tantanin halitta a cikin ƙananan kusurwar dama kuma ja ƙasa da adadin lokacin da ake buƙata layuka don shimfiɗa shi. Don haka an maye gurbin dabi'un sauran maganganu, wanda dole ne a rarrabu, da kuma cikar dabara ta atomatik.
Cikakken tsari na tsari yana da tsari = Levsimv (A1; Bincika (""; A1), zaka iya ƙirƙirar shi bisa ga ka'idodin da aka ambata ko kuma sakewa ya dace. Kar ka manta da maye gurbin tantanin halitta.
Mataki na 2: rabuwa da kalma ta biyu
Abu mafi wahala shine raba kalmar ta biyu, wanda a cikin shari'ar mu ita ce sunan. Wannan ya faru ne saboda gaskiyar cewa an kewaye ta da sarari daga bangarorin biyu, saboda haka dole ne ka bincika duka, ƙirƙira tsari na yau da kullun don madaidaicin lissafin da aka yi daidai.
- A wannan yanayin, babban dabara zai zama = PST (- rubuta shi a wannan fom, sannan ka je zuwa TARIHIN Saitunan Harafi.
- Wannan tsari zai bincika maɓallin da ake so a cikin rubutu, wanda aka zaɓa da sel tare da rubutu don rabuwa.
- Matsayin farko na layin dole ne a ƙaddara ta amfani da binciken da aka saba da binciken bincike na taimako na taimako ().
- Ingirƙira kuma yana motsawa zuwa gare shi, cika kamar yadda aka nuna a matakin da ya gabata. A matsayin rubutun da ake so, yi amfani da mai raba, kuma ka tantance tantanin halitta a matsayin rubutu don bincika.
- Komawa tsarin da ya gabata, inda aka ƙara aikin "Search" a ƙarshen don fara lissafi daga halaye na gaba bayan sarari da aka samo.
- Yanzu dabara na iya riga fara bincika layi daga sunan mutum na farko, amma har yanzu bai san inda ya gama da, saboda haka, a filin ") sake, rubuta tsarin bincike ().
- Ka je wa hujjojinta kuma ka cika su a cikin tsari da aka saba saba.
- A baya can, ba mu yi la'akari da farkon matsayin wannan aikin ba, amma yanzu ya zama dole don shigar da bincike (), tunda wannan tsari kada ya sami rata na farko, amma na biyu.
- Je zuwa aikin da aka kirkiro kuma a cika shi kamar yadda.
- Koma zuwa farkon "bincike" kuma ƙara a cikin "nach_position" +1 a ƙarshe, saboda ba ya buƙatar sarari don bincika layin, amma halayyar ta gaba.
- Danna kan tushen = pst kuma sanya siginan kwamfuta a ƙarshen layin "lamba_name".
- Cire bayyana maganar magana (""; A1) -1 don kammala lissafin sarari.
- Komawa tebur, shimfiɗa dabara ka tabbatar cewa an nuna kalmomin daidai.
Tsarin tsari ya juya babba, ba duk masu amfani sun fahimci daidai yadda yake aiki ba. Gaskiyar ita ce don bincika layin da dole ne in yi amfani da ayyuka da yawa da yawa waɗanda ke ƙayyade matsayi na farko da na ƙarshe na sarari, sannan alama ɗaya ta ɗauke su saboda haka a sakamakon haka, waɗannan gibin da aka bayyana. A sakamakon haka, da dabara ce wannan: = Pstr (A1; Bincika (""; A1) +1; Bincika (""; Bincika (""; Bincika (""; A1) -Poisk (""; A1) - 1). Yi amfani da shi azaman misali, maye gurbin lambar wayar tare da rubutu.
Mataki na 3: rabuwa da kalma ta uku
Mataki na ƙarshe na koyarwarmu ya haifar da rarraba kalma na uku, wanda yake kallo kamar yadda ya faru tare da farkon, amma tsarin ya bambanta da farko.
- A cikin kwayar wood, don wurin rubutu nan gaba, rubuta = Rasesimv (kuma ka je gardama wannan aikin.
- A matsayinka, saka tantanin halitta tare da rubutu don rabuwa.
- Wannan lokacin aiki na taimako don neman kalma ana kiranta DLstr (A1), inda A1 shine sel guda tare da rubutu. Wannan fasalin yana tantance adadin haruffa a cikin rubutu, kuma za mu ci gaba da rarraba kawai.
- Don yin wannan, ƙara -poisk () kuma je don shirya wannan dabara.
- Shigar da tsarin da ya riga ka bincika mai raba na farko a cikin kirtani.
- Sanya wani bincike don farawa ().
- Sanya shi iri ɗaya.
- Komawa zuwa Tsarin Bincike na baya.
- Ƙara +1 zuwa farkon matsayi.
- Kewaya zuwa tushen tsarin Rassish kuma tabbatar cewa an nuna sakamakon daidai, sannan ya tabbatar da canje-canje. Cikakken tsari a cikin wannan yanayin yana kama = prapstir (A1; dlstr (A1) -Poisk (""; A1; Bincika (""; A1).
- A sakamakon haka, a cikin allo na gaba zaka ga cewa duk kalmomin ukun an rarrabe daidai kuma suna cikin ginshiƙansu. A saboda wannan, ya zama dole a yi amfani da dabaru da yawa, amma yana ba ka damar fadada tebur da sauri kuma kada ku damu cewa duk lokacin da dole ne a sake yin rubutu. Idan ya cancanta, kawai faɗaɗa dabara ta hanyar motsa shi ƙasa saboda sel mai zuwa ana shafa su ta atomatik.