Yi aiki tare da aikin CLIP a Microsoft Excel

Daya daga cikin abubuwan ban sha'awa na Microsoft Excel shine aikin LATSA. Babban aikinta shi ne hada abubuwan da ke cikin sel biyu ko fiye da daya a cikin ɗaya. Wannan ma'aikacin yana taimakawa wajen magance wasu matsalolin da baza a iya aiwatar dasu ta amfani da sauran kayan aikin ba. Misali, tare da taimakonsa ya dace don aiwatar da tsarin hada sel ba tare da asara ba. Yi la'akari da kayan aikin wannan aikin da yanayin ƙarfin aikace-aikacensa.

Yin amfani da ma'aikacin CLICK

Aiki LATSA yana nufin rukuni na maganganun rubutu na Excel. Babban aikinta shine a hada a cikin sel ɗaya abubuwan da ke cikin sel da yawa, da kuma haruffa mutum. Farawa daga Excel 2016, ana amfani da aikin a maimakon wannan mai aiki SCEP. Amma don ci gaba da jituwa da baya, da afareta LATSA kuma hagu, kuma ana iya amfani dashi tare da SCEP.

Gaskiyar magana wannan bayanin ita ce:

= SAURARA (rubutu1; rubutu2; ...)

Muhawara na iya zama duka rubutu da kuma hanyar haɗi zuwa sel waɗanda ke ɗauke da shi. Yawan muhawara na iya bambanta daga 1 zuwa 255 m.

Hanyar 1: tattara bayanai a cikin sel

Kamar yadda kuka sani, haɗin sel na yau da kullun a cikin Excel yana haifar da asarar bayanai. Kawai bayanan da ke cikin ɓangaren hagu na sama an aje. Don haɗuwa da abubuwan da ke cikin sel biyu ko fiye a cikin Excel ba tare da asara ba, zaku iya amfani da aikin LATSA.

1. Zaɓi wayar da muke shirin sanya bayanan haɗin. Latsa maballin "Saka aikin". Yana da siffar gunki kuma yana gefen hagu na layin dabarun.



2. Yana buɗewa Mayan fasalin. A cikin rukuni "Rubutu" ko "Cikakken jerin haruffa" neman afareta CIGABA. Zaɓi wannan sunan kuma danna maballin. "Ok".



3. Farashin muhawara na aiki fara. Muhawara na iya zama nassi ga sel waɗanda ke ɗauke da bayanai ko rubutu dabam. Idan aikin ya haɗa da haɗa abubuwan da ke cikin sel, to a wannan yanayin za mu yi aiki ne kawai da hanyar haɗin kai.

   Sanya siginan kwamfuta a farkon farawar taga. Sannan zaɓi hanyar haɗi akan takardar, wanda ya ƙunshi bayanan da ake buƙata don ƙungiyar. Bayan an nuna kwastomomi a cikin taga, muna yin daidai tare da filin na biyu. Haka kuma, zaɓi wani sel. Muna yin irin wannan aiki har sai an shigar da hanyoyin dukkan sel waɗanda suke buƙatar haɗewa cikin taga muhawara na ayyuka. Bayan haka, danna maɓallin "Ok".



4. Kamar yadda kake gani, abubuwanda aka zaɓa sune aka nuna a cikin tantanin halitta da aka ayyana a baya. Amma wannan hanyar tana da mahimmancin hasara. Lokacin amfani da shi, abin da ake kira "sumul sum ɗin ɗaukar hoto" yana faruwa. Wato, babu sarari tsakanin kalmomin sannan ana gundura su cikin tsararru ɗaya. A wannan yanayin, ƙara sarari da hannu ba zai yi aiki ba, amma ta hanyar gyara dabara ne kawai.

Darasi: Wizard ɗin Aiki a cikin Excel

Hanyar 2: sanya aiki tare da sarari

Akwai dama don gyara wannan lahani ta hanyar sanya sarari tsakanin muhawara mai aiki.

1. Muna yin aikin ta amfani da wannan algorithm kamar yadda aka bayyana a sama.
2. Danna maɓallin linzamin kwamfuta na hagu sau biyu akan sel tare da dabara kuma kunna shi don gyara.



3. Tsakanin kowace takaddama, rubuta magana a cikin hanyar sarari, an ɗaure shi a ɓangarorin biyu ta hanyar maimaita sautin. Bayan shigar da kowane irin darajar, saka semicolon. Babban ɗayan ra'ayin da aka ƙara magana ya kamata ya zama kamar haka:

   " ";



4. Domin nuna sakamakon allon, danna maballin Shigar.

Kamar yadda kake gani, a wurin sa sarari tare da zato a cikin tantanin, an sami rarrabuwa tsakanin kalmomi.

Hanyar 3: kara sarari ta hanyar muhawara

Tabbas, idan babu wasu ɗimbin tuba da yawa, to zaɓin da ke sama don lalata hawan tare yana cikakke. Amma zai yi wuya a hanzarta aiwatar da shi idan akwai ƙwayoyin da yawa da suke buƙatar haɗuwa. Musamman idan waɗannan ƙwayoyin ba su cikin tsararru ɗaya. Muhimmin sauƙaƙe sanya sarari, zaku iya amfani da zaɓi don saka shi ta taga mai amfani.

1. Danna maɓallin linzamin kwamfuta na hagu sau biyu akan kowane ɓoyayyen sel akan takardar. Amfani da mabuɗin, saita sarari a ciki. Yana da kyau a nisanceshi daga manyan hanyoyin. Yana da muhimmanci sosai cewa wannan kwayar ba ta cika da kowane irin bayanai bayan wannan.



2. Muna yin ayyuka guda ɗaya kamar yadda a farkon hanyar amfani da aikin LATSA, har zuwa bude taga muhawara mai aiki. Theara darajar tantanin farko tare da bayanai a cikin filin taga, kamar yadda aka riga aka bayyana shi a baya. Sannan mun saita siginan kwamfuta a cikin filin na biyu, kuma zaɓi wayar mara amfani tare da sarari, wanda aka tattauna a baya. Haɗi yana bayyana a filin akwatin mai jayayya. Don hanzarta aiwatar da tsari, zaku iya kwafin shi ta sa alama da kuma danna maɓallin haɗin Ctrl + C.



3. Sannan muna ƙara hanyar haɗi zuwa kashi na gaba don ƙarawa. A filin na gaba, kara hanyar haɗi zuwa ragon tantanin kuma. Tunda muka kwafa adireshin ta, zamu iya sanya siginan kwamfuta a cikin filin kuma danna maɓallin key Ctrl + V. Za'a shigar da masu gudanarwa. Ta wannan hanyar, muna musanya filayen tare da adireshin abubuwan da babu komai a ciki. Bayan an shigar da dukkan bayanan, danna maɓallin "Ok".

Kamar yadda kake gani, bayan wannan, an kirkiro rikodin rikodin a cikin ƙwayar manufa, gami da abubuwan da ke ciki na dukkan abubuwan, amma tare da sarari tsakanin kowace kalma.

Hankali! Kamar yadda kake gani, wannan hanyar da ke sama tayi matukar hanzarta aiwatar da tsarin hada bayanai daidai cikin sel. Amma ya kamata a lura cewa wannan zaɓi yana da ɓarna. Yana da mahimmanci cewa a cikin kayan da ke ƙunshe da sarari, a tsawon lokaci wasu bayanai ba su bayyana ba ko kuma ba a canza shi ba.

Hanyar 4: hada ginshiƙai

Yin amfani da aiki LATSA Kuna iya haɗa bayanan sauri cikin ginshiƙai da yawa zuwa ɗaya.

1. Tare da sel na farkon layin da aka haɗa sassan, muna zaɓar ayyukan da aka nuna a cikin hanyoyin biyu da na uku na amfani da hujja. Koyaya, idan ka yanke shawarar amfani da hanyar tare da kwayar halitta, to wannan hanyar haɗin da ake buƙata zata buƙace ta zama ta ainihi. Don yin wannan, sanya alamar dala a gaban kowace alamar daidaitawa da tsaye a tsaye na wannan tantanin halitta ($). A zahiri, ya fi kyau a yi wannan tun farko, saboda a wasu wuraren da aka ƙunshi wannan adireshin, mai amfani zai iya kwafin shi ya ƙunshi madawwamin hanyoyin haɗin kai. A sauran filayen, bar hanyoyin haɗin dangi. Kamar yadda koyaushe, bayan hanya, danna maɓallin "Ok".



2. Mun sanya siginan kwamfuta a cikin ƙananan kusurwar dama na rabi tare da dabara. Wani gunkin yana bayyana wanda yayi kama da giciye, wanda ake kira mai cike da alamar. Riƙe maɓallin linzamin hagu ka ja shi ƙasa a layi ɗaya zuwa wurin abubuwan da za'a haɗa.



3. Bayan kammala wannan hanya, bayanan da ke cikin kundin da aka ƙayyade za a haɗasu cikin shafi ɗaya.

Darasi: Yadda ake hada ginshiƙai a cikin Excel

Hanyar 5: ƙara ƙarin haruffa

Aiki LATSA Hakanan ana iya amfani da shi don ƙara ƙarin haruffa da maganganun da ba su cikin asalin haɗuwa ba. Haka kuma, zaku iya aiwatar da wasu ma'aikatan ta amfani da wannan aikin.

1. Muna yin ayyuka don ƙara dabi'u zuwa taga muhawara na aiki ta amfani da kowane ɗayan hanyoyin da aka bayyana a sama. A ɗayan filayen (idan ya cancanta, za a iya samun dama) ƙara kowane kayan rubutu da mai amfani ya ɗauka ya zama dole don ƙarawa. Wannan rubutun dole ne a lullube shi cikin alamomin magana. Latsa maballin "Ok".



2. Kamar yadda kake gani, bayan wannan matakin, an ƙara kayan rubutu zuwa bayanan da aka haɗa.

Mai aiki LATSA - Hanya guda kawai don haɓaka ƙwayoyin marasa lalacewa a cikin Excel. Bugu da kari, ana iya amfani dashi dan hada dukkan bangarorin, da kara darajar rubutu, da kuma aiwatar da wasu hanyoyin. Ilimin algorithm don aiki tare da wannan aikin zai sauƙaƙa warware matsalolin da yawa ga mai amfani da shirin.