Yadda za a yi amfani da Sakamakon Ɗaidaicin Hanya
Ayyukan Excel RIGHT yana ba ka damar cire haruffa maras so daga bayanan da aka shigo. 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 bayanan rubutu a tantanin halitta, kamar sunan mutum amma ba sunan karshe.
A lokuta kamar waɗannan, Excel yana da ayyuka masu 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 yana dogara ne akan inda aka buƙata bayanin da aka buƙata dangane da abubuwan da ba a so a cikin tantanin halitta.
- Idan bayanin da aka buƙata yana a gefen dama na bayanan, yi amfani da aikin RIGHT don cire shi. Wannan koyawa zai nuna maka yadda ake amfani da wannan aikin.
- Idan bayanin da aka buƙata ya kasance a gefen hagu na bayanan, yi amfani da aikin LEFT don cire shi.
- Idan bayanan da ake buƙata yana da harafin da ba a so ba a garesu biyu, amfani da aikin MID don cire shi.
01 na 03
Hanyoyin Daidai da Magana
A cikin Excel, haɗin aikin yana nufin layout na aikin kuma ya haɗa da sunan aiki, parentheses, da muhawara .
Haɗin aikin aikin RIGHT shine:
= RIGHT (Rubutu, Num_chars)
Ayyukan aikin na gaya Excel abin da aka yi amfani da shi a cikin aikin kuma tsawon tsayin da za'a cire.
Rubutu- (Bukatar) shigarwar da ke dauke da bayanan da ake bukata. Wannan jayayya na iya kasancewa tantancewar salula zuwa wuri na bayanan a cikin takardun aiki , ko kuma zai iya zama ainihin rubutun da aka haɗa a alamomi.
Num_chars- (Zabin) yana ƙayyade yawan adadin haruffan a hagu na maganganun tayarwa da za a riƙe; an cire sauran haruffa. Wannan hujja dole ne ya fi girma ko kuma daidai da babu. Idan an tsayar da wannan gardama, aikin da ake amfani da shi na 1 shine amfani da aikin. Idan wannan ya fi tsawon rubutu, aikin zai dawo duk rubutu.
02 na 03
Misali: Cire Ayyukan Yanayin Ba tare da Wuta ba
Misali a cikin hoton da ke sama yana amfani da aikin RIGHT zuwa
- cire da kalmar Widget daga shigar da rubutu mafi tsawo * & ^% Widget dake cikin tantanin halitta B1 a cikin takardun aiki
- cire 789876 daga adadin da ake kira 123456789876 dake cikin tantanin halitta B2 a cikin takardun aiki
Da ke ƙasa akwai matakai da ke bayyani yadda aka samu sakamakon farko.
Zaɓuɓɓuka don shiga aikin RIGHT da kuma muhawararsa a cikin cell B1 sun hada da:
- Rubuta cikakken aikin = RIGHT (B1,6) zuwa cikin cell C1.
- Zaɓi aikin da muhawara ta amfani da maganganun aikin
Yin amfani da akwatin maganganu don shigar da aikin sau da yawa yana sauƙaƙa da ɗawainiyar, kamar yadda akwatin maganganun ke kula da aikin ta hanyar haɗawa ta hanyar shigar da sunan aikin, ƙungiyoyi masu rarraba, da ƙuƙwalwa a wurare da yawa da yawa.
Bayyanawa a Siffofin Cell
Ko wane irin zaɓin da ka zaɓa don shigar da aikin a cikin wani sashin layi, yana yiwuwa mafi kyau don amfani da nunawa don shigar da kowane maƙallan salula da aka yi amfani da ita azaman gardama.
Bayyanawa yana amfani da amfani da maɓallin linzamin kwamfuta don danna kan tantanin halitta don shigar da shi cikin aikin. Yin haka yana taimakawa wajen kawar da kurakurai da ta haifar da rubutu a cikin maɓallin ƙwayoyin salula.
Yin amfani da Akwatin Magana na Gaskiya
Shigar da ayyuka na RUKU da ƙididdigar zuwa cikin cell C1 ta yin amfani da akwatin maganganun aikin:
- Danna kan tantanin halitta C1 don sa shi tantanin halitta mai aiki - shi ne inda za a nuna sakamakon aikin.
- Danna maɓallin Formulas shafin na ribbon menu.
- Zaɓi Rubutu daga rubutun don buɗe jerin zaɓin jerin ayyuka.
- Danna madaidaicin a cikin jerin don kawo akwatin maganganu na aikin.
- A cikin akwatin maganganu, danna Rubutun rubutu .
- Danna sel B1 a cikin takardun aiki.
- Danna kan layin Num_chars .
- Rubuta a cikin lambar shida (6) a kan wannan layi tun da muna so mu ci gaba da haruffan haruffa shida.
- Danna Ya yi don kammala aikin kuma komawa cikin takardun aiki.
Rubutun da aka fitar da "Widget" ya kamata ya bayyana a cell C1.
Lokacin da ka danna kan tantanin halitta C1, cikakken aikin = RIGHT (B1,6) ya bayyana a cikin wannan tsari a sama da aikin aiki.
03 na 03
Lissafin Ƙidaya tare da Hanya Kyau
Kamar yadda aka nuna a jere na biyu na misalin da ke sama, za a iya amfani da aikin dama don cire samfuri na bayanan lambobi daga wani tsawon lokaci ta amfani da matakan da aka jera.
Iyakar matsalar shi ne cewa ana fitar da bayanai ne zuwa rubutu kuma baza'a iya amfani dashi a lissafin da ke ƙunshe da wasu ayyuka kamar SUM da AVERAGE ayyuka ba.
Ɗaya daga cikin hanyar da wannan matsala ita ce ta amfani da aikin NASAN don sauya rubutun a cikin lamba.
Misali:
= KASHI (RIGHT (B2, 6))
Hanya na biyu shine don amfani da manna na musamman don maido da rubutu zuwa lambobi .