01 na 02
Ayyukan Shafukan Google'''Munni na Farko
Lokacin da aka shigo da bayanan rubutu ko a kwafe zuwa cikin wani ɗan littafin Rubutun Google ɗin karin wasu lokuta ana haɗa tare da bayanan rubutu.
A kan kwamfuta, sarari tsakanin kalmomin ba wuri ba ne amma wani hali, kuma, waɗannan haruffan haruffa zasu iya rinjayar yadda aka yi amfani da bayanai a cikin takardun aiki - irin su a cikin aikin CONCATENATE wanda ya haɗu da kwayoyin halitta masu yawa a cikin ɗaya.
Maimakon yin gyare-gyaren hannu don gyara bayanan da ba'a so ba, yi amfani da aikin TRIM don cire karin wurare daga tsakanin kalmomi ko wasu kalmomin rubutu .
Hanyoyin Gudanar da Harkokin Sanya da Magana
Haɗin aikin yana nufin layout na aikin kuma ya haɗa da sunan aikin, shafuka, da muhawara .
Haɗin aikin na TRIM shine:
= TRIM (rubutu)
Shawara don aikin TRIM shine:
rubutu - bayanan da kake so ka cire wurare daga. Wannan zai iya zama:
- ainihin bayanai da za a shirya
- tantancewar tantanin halitta zuwa wurin da aka sanya bayanan rubutu a cikin takardun aiki
Lura: Idan ana amfani da ainihin bayanan da ake amfani dasu don maganganun rubutu , dole ne a haɗa shi cikin alamomi, kamar:
= TRIM ("Cire karin wurare")Ana cire bayanan asali tare da Manna Musamman
Idan ana amfani da tantanin tantanin halitta zuwa wurin da aka sanya bayanai don amfani da shi azaman maganganun rubutu , aikin ba zai iya zama a cikin tantanin halitta ba as asalin asalin.
A sakamakon haka, dole ne ainihin rubutun da aka shafi rubutu ya kasance a wurin da aka keɓa a cikin takardun aiki. Wannan zai iya gabatar da matsalolin idan akwai babban adadin bayanai da aka ƙayyade ko kuma idan asalin asalin an samo a cikin wani wuri mai muhimmanci.
Wata hanya a kan wannan matsala shine a yi amfani da Ƙasar ɗin Musamman don kawai ƙididdiga bayanan bayan an kayyade bayanan. Wannan yana nufin cewa sakamakon aikin na TRIM zai iya komawa bayan bayanan asali sannan a cire aikin TRIM.
Alal misali: Cire Ƙananan Ƙaura tare da aikin Ginin
Wannan misali ya haɗa da matakai da suka dace don:
- cire karin wurare daga tsakanin layi uku na rubutu a cikin layuka 1 zuwa 3 a cikin takardun aiki - kamar yadda aka nuna a hoton da ke sama;
- za a kwafe bayanan da aka ƙayyade sannan a ɗefa na musamman don maye gurbin bayanan asali a cikin layuka uku na farko;
- za a cire ayyukan TRIM da ake amfani da su don cire sauran wurare.
Shigar da Bayanan Tutorial
- Bude Ɗaukar Lissafi ta Google da ke da rubutun da ya ƙunshi karin wurare da ake buƙatar cirewa, ko kwafa da manna layin da ke ƙasa zuwa cikin sel A1 zuwa A3 a cikin takardun aiki Row 1 na Bayanai tare da Ƙananan Hoto Row 2 na Bayanai tare da Ƙananan Haɗin Jeri 3 na Data tare da Ƙarin Ruwa
02 na 02
Shigar da Hanya Gudun
Shigar da Hanya Gudun
Fayil ɗin Shafukan Google bazai amfani da akwatunan maganganu don shigar da muhawarar aiki kamar yadda ake samu a Excel. Maimakon haka, yana da akwati na nuna kai tsaye wanda ya tashi kamar yadda aikin aikin ya shiga cikin tantanin halitta.
- Idan kana amfani da bayananka, danna kan tantanin aikin aiki inda kake so bayanan da aka tsara don zama
- idan kun bi wannan misali, danna kan A6 don yin shi tantanin halitta - wannan shine inda aikin TRIM zai shiga kuma inda za'a nuna rubutun edita.
- Rubuta alamar daidai (=) biye da sunan aikin ginin
- Yayin da kake bugawa, akwatin zane - zane yana nuna tare da sunayen ayyukan da suka fara tare da harafin T
- Lokacin da sunan TRIM ya bayyana a cikin akwati, danna sunan tare da maɓallin linzamin kwamfuta don shigar da sunan aikin kuma buɗe sashin zagaye a cikin cell A6
Shigar da Magana ta Magana
Kamar yadda aka gani a hoton da ke sama, an shigar da hujja don aikin TRIM bayan bayanan zagaye.
- Danna kan salula A1 a cikin takardun aiki don shigar da wannan tantanin halitta kamar maganganun rubutu
- Latsa maɓallin shigarwa a kan keyboard don shigar da takalmin rufewa " ) " bayan bayanan aikin kuma don kammala aikin
- Layin rubutun daga cell A1 ya kamata ya bayyana a cikin salula A6, amma tare da wuri daya tsakanin kowace kalma
- Lokacin da ka danna kan salula A6 cikakken aikin = TRIM (A1) ya bayyana a cikin maɓallin tsari a sama da takardun aiki.
Kashe aikin tare da cika cika
Ana amfani da ƙoshin cika don kwafe aikin TRIM a cikin salula A6 zuwa sassan A7 da A8 don cire karin wurare daga layin rubutun cikin sassan A2 da A3.
- Danna kan salula A6 don sa shi tantanin halitta mai aiki
- Sanya maƙalin linzamin kwamfuta a kan kusurwar baki a cikin kusurwar dama na kusurwa na cell A6 - maƙerin zai canza zuwa alamar " + "
- Danna kuma ka riƙe maɓallin linzamin hagu na hagu kuma ja da ƙoshin da aka cika zuwa cell A8
- Saki da maballin linzamin kwamfuta - Kwayoyin A7 da A8 ya kamata su hada da rubutun da aka tsabtace daga kwayoyin A2 da A3 kamar yadda aka nuna a hoton a shafi na 1
Ana cire bayanan asali tare da Manna Musamman
Bayanai na asali a cikin kwayoyin A1 zuwa A3 za a iya cire ba tare da amfani da bayanan da aka ƙayyade ba ta hanyar amfani da ƙwaƙwalwar mai ƙira ta musamman don ƙura bayanai na asali a cikin kwayoyin A1 zuwa A3.
Bayan wannan, TRIM aiki a cikin kwayoyin A6 zuwa A8 za a cire su tun lokacin da ba a buƙace su ba.
#ref! kurakurai : idan ana amfani da aikin yau da kullum da kuma manna maimakon ƙididdigar ƙididdigar , ayyukan TRIM za a ƙaddamar da su cikin sassan A1 zuwa A3, wanda zai haifar da yawancin #REF! Ana nuna kuskure a cikin takardun aiki.
- Sanya lambobin A6 zuwa A8 a cikin takardun aiki
- Kwafi bayanai a cikin wadannan kwayoyin ta amfani da Ctrl C a kan maɓalli ko Shirya> Kwafi daga menus - ya kamata a kayyade sifofin guda uku tare da iyakar layin da aka lalata don nuna cewa ana kofe su
- Danna kan salula A1
- Danna kan Shirya> Haɗa na musamman> Taɗa dabi'u kawai a cikin menus don manna kawai sakamakon aikin TRIM a cikin sel A1 zuwa A3
- Ya kamata a daidaita rubutun da aka ƙayyade a cikin sel A1 zuwa A3 da kuma sassan A6 zuwa A8
- Sanya lambobin A6 zuwa A8 a cikin takardun aiki
- Latsa Maɓallin sharewa a kan keyboard don share ayyukan TRIM guda uku
- Bayanan da aka ƙayyade ya kamata a kasance a cikin sel A1 zuwa A3 bayan an share ayyukan