01 na 01
Ayyuka na Excel MIDB da ayyukan MIDB
Lokacin da aka kwashe rubutu ko a shigo da shi zuwa Excel, wasu lokuta ba a buƙaɗɗa su a wasu lokuta tare da bayanan mai kyau.
Ko, akwai lokutan da ake buƙatar ɓangaren rubutu kawai a cikin tantanin halitta - kamar sunan mutum amma ba sunan karshe.
Don lokuta kamar waɗannan, Excel yana da ayyuka da yawa waɗanda za a iya amfani da su don cire bayanin da ba'a so daga sauran.
Wanne aikin da kake amfani da shi ya dogara ne akan inda kyakkyawan bayanin ke samuwa dangane da abubuwan da ba a so a cikin tantanin halitta.
- Idan bayanan mai kyau, ko maɓallin da za a riƙe, yana a gefen dama na bayanan, yi amfani da aikin RIGHT don cire shi.
- Idan madogarar yana kan gefen hagu na bayanan, yi amfani da aikin LEFT don cire shi.
- Idan murda yana da harafin da ba a so ba a garesu biyu, amfani da ayyukan MID ko MIDB don cire shi.
MID da MIDB
Ayyukan MID da MIDB sun bambanta ne kawai a cikin harsuna da suke tallafawa.
MID shi ne don harsuna da suke amfani da saitunan haɗin kai ɗaya - wannan rukuni ya haɗa da yawancin harsunan kamar Turanci da dukan harsunan Turai.
MIDB ne don harsuna da ke amfani da halayyar halayen nau'i-nau'in - ya hada da Jafananci, Sinanci (Saukake), Sinanci (Gargajiya), da Koriya.
MID da MIDB Daidaita aiki da jayayya
A cikin Excel, haɗin aikin yana nufin layout na aikin kuma ya haɗa da sunan aiki, shafuka, da muhawara .
Haɗin aikin aikin MID shine:
= MID (Rubutu, Fara_num, Num_chars)
Haɗin aikin MIDB shine:
= MIDB (Rubutu, Start_num, Num_bytes)
Wadannan muhawara suna gaya wa Excel
- abin da bayanai za a yi amfani dashi a cikin aikin;
- wuri na farawa na bayanan mai kyau ko kuma abin da za'a cire shi;
- tsawon tsawon maɓallin.
Rubutu - (da ake buƙata don aikin MID da MIDB ) rubutun kalmomin da ke dauke da bayanai da ake bukata
- wannan hujja na iya zama ainihin kirtani ko tantancewar salula akan wurin da aka sanya bayanai a cikin takardun aiki - layuka 2 da 3 a cikin hoton da ke sama.
Start_num - (da ake buƙata don MID da MIDB aiki) ya ƙayyade halin farawa daga gefen hagu na substring don a kiyaye shi.
Num_chars - (da ake buƙata don aikin MID ) yana ƙayyade adadin haruffa zuwa dama na Start_num da za a riƙe.
Num_bytes (wanda ake buƙata don aikin MIDB ) yana ƙayyade adadin haruffa - a cikin bytes - zuwa dama na Start_num da za a riƙe.
Bayanan kula:
Idan Start_num ya fi tsayin rubutu na rubutu, MID / MIDB ya sake dawowa cell - blanki 4 na hoton, inda Start_num ya daidaita da 14, kuma nau'in rubutu ne kawai haruffa 13 kawai.
Idan Start_num ya kasa da 1 ko Num_chars / Num_bytes babanci ba ne aikin MID / MIDB zai dawo #VALUE! Ƙimar kuskure - jere na 6 na hoton, inda Start_num ya daidaita da -1.
Idan Num_chars / Num_bytes na nuni da maras amfani ko kuma an saita su a cikin kome, MID / MIDB ya sake dawowa cell salula - layi na 7 na hoton, inda Num_chars ke nuni da bashi B13.
MID Alamar Example - Cire Bayanan Mai kyau daga Bad
Misali a cikin hoton da ke sama ya nuna hanyoyi da dama don amfani da aikin MID don cire wani adadi na ainihi daga haruffa daga rubutu, ciki har da shigar da bayanai kai tsaye kamar yadda muhawara don aikin - jere 2 - da kuma shigar da sassan layi ga dukan muhawara guda uku - jere 5.
Tun da yake yawanci ya fi dacewa da shigar da labaran sakonni don jayayya maimakon ainihin bayanan, bayanin da ke ƙasa ya lissafa matakan da ake amfani dasu don shigar da aikin MID da maganganunsa zuwa cikin C5.
Akwatin Magana ta MID
Zaɓuɓɓuka don shigar da aikin da ƙwaƙwalwar zuwa cikin cell C5 sun haɗa da:
- Rubuta cikakken aikin: = MID (A3, B11, B12) zuwa cikin cell C5.
- Zabi aikin da muhawara ta amfani da maganganun aikin
Yin amfani da akwatin maganganu don shigar da aikin sau da yawa yana sauƙaƙa ɗawainiya kamar akwatin maganganu yana kula da haɗin aikin - shigar da sunan aikin, ƙungiyoyi masu rarraba, da ƙuƙwalwa a wurare da yawa da yawa.
Bayyanawa a Siffofin Cell
Duk wanda zabin da ka zaba don shigar da aikin a cikin sallar ɗawainiya, mai yiwuwa ya fi dacewa don amfani da maɓallin kuma danna don shigar da kowane siginar salula da aka yi amfani da shi azaman muhawara don rage girman kuskuren da ake haifarwa ta hanyar rubutawa a cikin maƙasudin salon salula.
Yin amfani da akwatin maganganu na MID
- Danna kan tantanin halitta C1 don sa shi tantanin halitta - wannan shine inda za a nuna sakamakon aikin;
- Danna maɓallin Formulas na shafin ribbon ;
- Zabi Rubutu daga rubutun don buɗe jerin abubuwan da aka sauke aikin;
- Danna MID a jerin don kawo akwatin maganganu na aikin;
- A cikin akwatin maganganu, danna kan Rubutun Labaran cikin akwatin maganganu;
- Danna kan salula A5 a cikin takardar aiki don shigar da wannan tantanin halitta kamar Magana na Text ;
- Danna maɓallin Start_num
- Danna kan B12 na cikin aiki don shigar da wannan tantanin halitta;
- Danna kan layin Num_chars ;
- Danna sel B12 a cikin takarda don shigar da wannan tantanin halitta;
- Danna Ya yi don kammala aikin kuma rufe akwatin maganganu;
- Fassarar fayil na madaurin # 6 ya kamata ya bayyana a cell C5;
- Lokacin da ka danna kan tantanin C5 da cikakken aikin = MID (A3, B11, B12) ya bayyana a cikin maɓallin tsari a sama da aikin aiki.
Littafin Lissafi da aikin MID
Kamar yadda aka nuna a cikin jere takwas misalai a sama, ana iya amfani da aikin MID don cire samfuri na bayanan lambobi daga lamba mai tsawo ta amfani da matakan da aka lissafa a sama.
Iyakar matsalar shi ne cewa ana fitar da bayanan da aka cire zuwa rubutu kuma ba za a iya amfani da shi a lissafin da ya shafi wasu ayyuka - kamar SUM da AVERAGE ayyuka.
Ɗaya hanyar da za a fuskanci wannan matsala ita ce yin amfani da aikin ƘARARI don maido da rubutu zuwa lamba kamar yadda aka nuna a jere na 9 a sama:
= KASHI (MID (A8,5,3))
Hanya na biyu shine don amfani da manna na musamman don juyar da rubutu zuwa lambobi .