Hanyoyi 6 don maye gurbin ma'anar tare da wasan kwaikwayo a Microsoft Excel

Yawancin masu amfani da shirin Excel suna fuskantar batun maye gurbin dige tare da wakafi a tebur. Wannan mafi yawancin lokuta saboda gaskiyar cewa a cikin ƙasashen da ke magana da Ingilishi al'ada ce a rarraba ƙananan gebbai na decress daga lamba daga dot, kuma a cikin yanayinmu, ta wakafi. Mafi muni, lambobi masu ma'ana ba a gane su a cikin fasalin na Rasha na Excel a matsayin tsari mai lamba. Sabili da haka, wannan jagorar na musamman na canji ya dace sosai. Bari mu bincika yadda za a canza maki zuwa semicolons a Microsoft Excel ta hanyoyi daban-daban.

Hanyoyi don canza ra'ayi zuwa wakafi

Akwai hanyoyi da yawa da aka tabbatar don canza aya zuwa wakafi a cikin Excel. Wasu daga cikinsu ana warware su ta amfani da aikin wannan aikace-aikacen, kuma don amfanin wasu, ana buƙatar amfani da shirye-shiryen ɓangare na uku.

Hanyar 1: Nemo da Sauya kayan aiki

Hanya mafi sauki don maye gurbin dige da waƙafi shine amfani da damar da kayan aikin ke samarwa. Nemo ka Sauya. Amma, kuna buƙatar yin hankali tare da shi. Bayan haka, idan aka yi amfani da shi ba daidai ba, duk abubuwan da ke kan takardar za a maye gurbinsu, har a wuraren da ake buƙatar su sosai, alal misali, a cikin kwanakin. Sabili da haka, dole ne a yi amfani da wannan hanyar a hankali.

1. Kasancewa a cikin shafin "Gida", a cikin rukunin kayan aiki "Gyara" a kan tef danna kan maɓallin Nemo da Haskaka. A cikin menu wanda ya bayyana, je zuwa abun Sauya.



2. Window yana buɗewa Nemo ka Sauya. A fagen Nemo saka alamar dot (.). A fagen Sauya - alamar wakafi (,). Latsa maballin "Zaɓuɓɓuka".



3. Searcharin bincike da maye gurbin zaɓuɓɓuka suna buɗe. M misali "Sauya tare da ..." danna maballin "Tsarin".



4. Ana buɗe wata taga wadda za mu iya saita tsarin tantanin halitta nan da nan a canja, duk abin da yake a da. A cikin lamarinmu, babban abu shine kafa tsarin data lambobi. A cikin shafin "Lambar" tsakanin saiti na nau'in tsarin lamba, zabi abu "Lambar". Latsa maballin "Ok".



5. Bayan mun dawo taga Nemo ka Sauya, zaɓi duk kewayon sel akan takardar, inda zai zama dole a sauya ma'anar da wakafi. Wannan yana da mahimmanci, saboda idan ba ku zaɓi yanki ba, to musanyawar za ta faru a ko'ina cikin takardar, wanda ba koyaushe ake buƙata ba. To, danna kan maɓallin Sauya Duk.

Kamar yadda kake gani, maye gurbin yayi nasara.

Darasi: Sauya hali a cikin Excel

Hanyar 2: yi amfani da aikin SUBSTITUTE

Wani zabin don maye gurbin lokaci da wakafi shine amfani da aikin SUBSTITUTE. Koyaya, lokacin amfani da wannan aikin, maye gurbin ba ya faruwa a cikin sel na ainihi, amma an nuna shi a cikin wani keɓaɓɓen shafi.

1. Zaɓi tantanin halitta, wanda zai zama farkon farko a cikin shafi don nuna bayanan da aka sauya. Latsa maballin "Saka aikin", wanda ke hagu zuwa hagu na wurin murfin aikin.



2. Mai maye aikin yana farawa. A cikin jerin da aka gabatar a cikin taga bude, muna neman aiki SAURARA. Zaɓi shi kuma danna maballin. "Ok".



3. Ana kunna taga aikin aiki. A fagen "Rubutu" kuna buƙatar shigar da daidaitawa na tantanin farko na shafi inda lambobi masu ɗigo suke. Ana iya yin wannan ta hanyar zaɓar wannan kwayar a kan takarda tare da linzamin kwamfuta. A fagen "Star_text" shigar da zance (.). A fagen "Sabon_rafin" saka wakafi (,). Filin Shigarwa_ babu buƙatar cika. Aikin da kansa zai sami wannan tsarin: "= SUBSTITUTE (cell_address;". ";", ",") ". Latsa maballin "Ok".



4. Kamar yadda kake gani, a cikin sabuwar sel, lambar tana da wakafi maimakon aya. Yanzu muna buƙatar yin irin wannan aiki don duk sauran ƙwayoyin da ke cikin shafi. Tabbas, baku buƙatar shigar da aiki don kowane lamba, akwai hanya mafi sauri don aiwatar da juyawa. Mun tsaya a ƙananan gefen dama na tantanin halitta wanda ya ƙunshi bayanan da aka sauya. Alamar cike take bayyana. Riƙe maɓallin linzamin kwamfuta na hagu, ja shi zuwa ƙananan iyakar yankin wanda ke ɗauke da bayanan da za a canza.



5. Yanzu muna buƙatar sanya tsari lamba ga sel. Zaɓi duk yankin da aka canza bayanai. A kan kintinkiri a cikin shafin "Gida" neman akwatinan kayan aiki "Lambar". A cikin jerin zaɓi, canza tsari zuwa lamba.

Wannan ya kammala juya data.

Hanyar 3: amfani da macro

Hakanan zaka iya maye gurbin ma'ana tare da waka a cikin Excel ta amfani da macro.

1. Da farko dai, kuna buƙatar kunna macros da shafin "Mai Haɓakawa"idan ba a hada su da ku ba.



2. Je zuwa shafin "Mai Haɓakawa".



3. Latsa maballin "Kayayyakin aikin Kayan gani".



4. A cikin taga edita wanda zai buɗe, liƙa wannan lambar:

   Sub Comma_Replacement_ Macro
Zaɓi.Raɗa Abinda: = ".", Sauyawa: = ","
Are ƙarshen

   Rufe edita.



5. Zaɓi yankin sel a kan takardar da kake son juyawa. A cikin shafin "Mai Haɓakawa" danna maballin Macros.



6. A cikin taga da ke buɗe, an gabatar da jerin jerin macros. Zabi daga jerin Macro yana maye gurbin waka da dige. Latsa maballin Gudu.

Bayan haka, ana juyar da maki a waƙafi a cikin zaɓaɓɓen ƙwayoyin sel.

Hankali! Yi amfani da wannan hanyar a hankali. Sakamakon wannan Macro ba a jujjuyawa ba, saboda haka zaɓi waɗannan sel waɗanda kuke so ku sa su.

Darasi: yadda zaka kirkiri wani macro a Microsoft Excel

Hanyar 4: yi amfani da notepad

Hanya ta gaba ta hada da kwafin bayanai a cikin daidaitaccen rubutun edita Windows Notepad, da canza su a cikin wannan shirin.

1. A cikin Excel, zaɓi yanki na sel waɗanda kuke so ku musanya aya tare da wakafi. Danna dama. A cikin mahallin menu, zaɓi Kwafa.



2. Buɗe notepad. Mun danna-dama, kuma a cikin jerin da ya bayyana, danna kan abu Manna.



3. Danna kan abun menu Shirya. Cikin jeri wanda ya bayyana, zaɓi Sauya. Ko kuma, zaku iya rubuta haɗin maɓalli a kan maballin Ctrl + H.



4. Binciken da maye gurbin taga yana buɗewa. A fagen "Me" kawo karshen. A fagen "Sama da" - wakafi Latsa maballin Sauya Duk.



5. Zaɓi bayanan da aka canza a Notepad. Danna-dama, kuma a cikin jerin, zaɓi Kwafa. Ko latsa mabuɗin keyboard Ctrl + C.



6. Mun koma ga Excel. Zaɓi kewayon sel inda ya kamata a musanya abubuwan. Mun danna shi tare da maɓallin dama. A cikin menu wanda ya bayyana a cikin ɓangaren Saka Zabi danna maballin "Ajiye rubutu kawai". Ko kuma, danna maɓallin kewayawa Ctrl + V.



7. Don duka kewayon sel, saita tsarin lamba kamar yadda muka yi a baya.

Hanyar 5: canza saitunan Excel

A matsayin hanyar ɗaya ta sauya lokaci zuwa wakafi, zaku iya amfani da canji a cikin saitunan shirye-shiryen Excel.

1. Je zuwa shafin Fayiloli.



2. Zaɓi ɓangaren "Zaɓuɓɓuka".



3. Je zuwa nuna "Ci gaba".



4. A sashen saiti Shirya Zaɓuka Cire kayan "Yi amfani da tsarin raba tsarin". A cikin filin da aka kunna "Mai rarrabe abubuwa gaba ɗaya kawo karshen. Latsa maballin "Ok".



5. Amma, bayanan da kansu ba zai canza ba. Mun kwafe su cikin notepad, sannan mu liƙa su a wuri guda a yadda aka saba.



6. Bayan an kammala aikin, ana bada shawara don dawo da saitunan Excel zuwa tsoho.

Hanyar 6: canza tsarin saiti

Wannan hanyar tana kama da wacce ta gabata. Kawai wannan lokacin ba mu canza saitin Excel ba. Kuma tsarin tsarin Windows.

1. Ta hanyar menu Fara mun shiga "Kwamitin Kulawa".



2. A cikin Kwamitin Gudanarwa, je zuwa sashin "Clock, harshe da yanki".



3. Je zuwa sashin yanki "Harshe da matsayin yanki".



4. A cikin taga yana buɗewa, a cikin shafin "Formats" danna maballin "Saitunan ci gaba".



5. A fagen "Mai rarrabe abubuwa gaba ɗaya canza wakafi zuwa aya. Latsa maballin "Ok".



6. Kwafa bayanai ta hanyar Notepad zuwa Excel.



7. Mun dawo da saitunan Windows da suka gabata.

Batu na karshe yana da matukar muhimmanci. Idan baku aikata shi ba, to bazaka iya aiwatar da ayyukan lissafin da aka saba tare da bayanan da aka canza ba. Bugu da kari, sauran shirye-shiryen da aka sanya a kwamfutar na iya yin aiki daidai.

Kamar yadda kake gani, akwai hanyoyi da yawa da zaka iya musanya aya da waka a cikin Microsoft Excel. Tabbas, yawancin masu amfani sun fi son yin amfani da kayan aiki mafi sauƙi da dacewa don wannan hanyar. Nemo ka Sauya. Amma, rashin alheri, a wasu yanayi tare da taimakonsa ba zai yiwu a canza bayanan daidai ba. Sannan sauran hanyoyin magance matsalar na iya zuwa don agazawa.