Canza wakafi tare da wani lokaci a Microsoft Excel

An sani cewa a cikin fasalin Rasha na Excel, ana amfani da wakafi azaman mai keɓewa, yayin da a cikin Ingilishi ana amfani da lokaci. Hakan yana faruwa ne saboda wanzuwar ɗabi'a iri daban-daban a wannan fagen. Bugu da kari, a cikin kasashen jin Turanci al'ada ce ta amfani da waka a matsayin rabuwa, kuma a halinmu lokaci. Bi da bi, wannan yana haifar da matsala lokacin da mai amfani ya buɗe fayil ɗin da aka kirkira a cikin shirin tare da wata ƙasa daban. Ya isa ga cewa Excel bai ma la'akari da tsarin ba, saboda yana ganin alamun ba daidai ba. A wannan yanayin, dole ne ko dai canza fassarar shirin a cikin saitunan, ko maye gurbin haruffan da ke cikin daftarin. Bari mu gano yadda za a canza wakafi zuwa wani abu a cikin wannan aikace-aikacen.

Hanyar sauyawa

Kafin ci gaba da sauyawa, da farko kuna buƙatar fahimtar da kanku abin da kuke yi. Abu daya ne idan ka aiwatar da wannan hanya kawai saboda ka fahimci hangen nesa a matsayin mai rabuwa kuma baka shirin amfani da wadannan lambobin a cikin lissafin. Abu ne daban daban idan kana bukatar sauya alamar daidai ga lissafi, tunda nan gaba za a aiwatar da kundin a cikin Ingilishi na Excel.

Hanyar 1: Nemo da Sauya kayan aiki

Hanya mafi sauki don sauya wakafi zuwa wani abu shine amfani da kayan aiki Nemo ka Sauya. Amma, ya kamata a sani yanzunnan cewa wannan hanyar ba ta dace da lissafin ba, tunda za a juya abubuwan da ke cikin sel zuwa tsarin rubutu.

1. Mun zabi yanki akan takaddun inda kake son canza wakafi zuwa maki. Yi danna maɓallin dama. A cikin menu na mahallin da ke farawa, yi alama abun "Tsarin kwayar halitta ...". Wadancan masu amfani waɗanda suka fi son amfani da zaɓuɓɓuka masu amfani tare da yin amfani da "maɓallan zafi", bayan ba da alama, za su iya buga haɗin maɓallan Ctrl + 1.



2. Ana ƙaddamar da taga tsarawa. Matsa zuwa shafin "Lambar". A rukunin sigogi "Lambobin adadi" matsar da zabi zuwa wuri "Rubutu". Don adana canje-canje, danna kan maɓallin "Ok". Tsarin bayanai a cikin zangon da aka zaɓa za'a juya shi zuwa rubutu.



3. Kuma, zaɓi kewayon manufa. Wannan lamari ne mai mahimmanci, saboda ba tare da warewa na farko ba, za a aiwatar da canjin a duk faɗin yankin, kuma wannan yana da nisa koyaushe. Bayan an zaɓi yankin, matsa zuwa shafin "Gida". Latsa maballin Nemo da Haskakawanda yake a cikin shinge na kayan aiki "Gyara" a kan tef. Sai ƙaramin menu ya buɗe, a cikin abin da ya kamata ka zaɓa "Sauya ...".



4. Bayan wannan, kayan aiki yana farawa Nemo ka Sauya a cikin shafin Sauya. A fagen Nemo saita alamar ",", kuma a cikin filin "Sauya tare da" - ".". Latsa maballin Sauya Duk.



5. Ana buɗe taswirar bayani inda aka bayar da rahoto game da cikakken canjin da aka samar. Latsa maballin "Ok".

Shirin yana aiwatar da aikin sauya wakafi zuwa maki a cikin zabi da aka zaɓa. A kan wannan, ana iya ɗaukar wannan matsalar. Amma ya kamata a tuna cewa bayanan da aka maye gurbinsu ta wannan hanyar zasu sami tsarin rubutu, kuma, sabili da haka, baza'a iya amfani dashi a cikin lissafin ba.

Darasi: Maye gurbin Haraji a Excel

Hanyar 2: sanya aikin

Hanya na biyu ya ƙunshi yin amfani da injin SAURARA. Da farko, amfani da wannan aikin, muna sauya bayanan a wani keɓance daban, sannan kuma kwashe su zuwa asalin wurin.

1. Zaɓi sel mara komai akasin sashin farko na kewayon bayanai wanda yakamata a canza wa dola. Danna alamar. "Saka aikin"an sanya shi a hagu na dabarar dabara.



2. Bayan waɗannan ayyuka, Za a ƙaddamar da Wurin Aiki. Muna neman shiga rukuni "Gwaji" ko "Cikakken jerin haruffa" suna SAURARA. Zaɓi shi kuma danna maballin. "Ok".



3. Farashin muhawara na aiki zai bude. Tana da hujjoji guda uku. "Rubutu", "Tsohon rubutu" da "Sabon rubutu". A fagen "Rubutu" kuna buƙatar tantance adireshin tantanin inda bayanan yake, wanda ya kamata a canza. Don yin wannan, saita siginan kwamfuta a cikin wannan filin, sannan danna kan takardar a farkon sel na kewayon m. Nan da nan bayan haka, adireshin zai bayyana a taga muhawara. A fagen "Tsohon rubutu" saita hali na gaba - ",". A fagen "Sabon rubutu" sanya magana - ".". Bayan an shigar da bayanai, danna maballin "Ok".



4. Kamar yadda kake gani, juyawa yayi nasara ga tantanin farko. Ana iya aiwatar da irin wannan aiki ga duk sauran ƙwayoyin sel da ake so. Da kyau, idan wannan kewayon ƙarami ne. Amma idan ta ƙunshi ƙwayoyin da yawa? Tabbas, canji ta wannan hanyar, a wannan yanayin, zai ɗauki lokaci mai yawa. Amma, ana iya haɓaka hanyar sosai ta hanyar kwafin dabara SAURARA amfani da alamar mai cikawa.

   Mun sanya siginan kwamfuta a cikin ƙananan gefen dama na tantanin halitta wanda aikin ya ƙunsa. Alamar cike take bayyana azaman karamin giciye. Riƙe maɓallin linzamin kwamfuta na hagu ka ja wannan giciye a gefen da kake son juyar da wakafi zuwa maki.



5. Kamar yadda kake gani, duk abinda ke cikin kwastomomin da aka yi niyya an canza su zuwa bayanai tare da lokaci maimakon wakafi. Yanzu kuna buƙatar kwafa sakamakon kuma manna shi a cikin asalin tushen. Zaɓi ƙwayoyin tare da dabara. Kasancewa a cikin shafin "Gida"danna maballin akan kintinkiri Kwafalocated a cikin kungiyar kayan aiki Clipboard. Ana iya samun sauƙi mafi sauƙi, wato, bayan zaɓar kewayon, buga maɓallan maɓallan akan maballin Ctrl + 1.



6. Zaɓi maɓallin asalin. Mun danna kan zaɓi tare da maɓallin linzamin kwamfuta na dama. Maɓallin mahallin ke bayyana. A ciki, danna kan kayan "Dabi'u"wanda ke cikin rukuni Saka Zabi. Ana nuna wannan abun ta lambobi. "123".



7. Bayan waɗannan matakan, za a shigar da ƙimar a cikin kewayon da ya dace. A wannan yanayin, wayoyin dogo za a canza zuwa maki. Don share yanki wanda ba mu sake buƙata ba, cike da dabaru, zaɓi shi da danna-dama. A cikin menu wanda ya bayyana, zaɓi Share Abun ciki.

An kammala juzu'i na bayanan kompu-da-dot, kuma an share duk abubuwan da basu dace ba.

Darasi: Wizard ɗin Aiki a cikin Excel

Hanyar 3: Yin Amfani da Macro

Hanya na gaba don canza wakafi zuwa maki shine ta hanyar amfani da macros. Amma, abu shine cewa macros a cikin Excel suna da nakasa ta hanyar tsohuwa.

Da farko, kunna macros kuma kunna shafin "Mai Haɓakawa"idan a cikin shirin ku har yanzu ba a kunna su ba. Bayan haka, kuna buƙatar yin waɗannan ayyukan:

1. Matsa zuwa shafin "Mai Haɓakawa" kuma danna maballin "Kayayyakin aikin Kayan gani"wanda yake a cikin shinge na kayan aiki "Lambar" a kan tef.



2. Edita na macro ya buɗe. Saka lambar da ke ciki:

   Sub Comma_Transformation_Macro_Macro ()
Zaɓi.Replace Abin: = ",", Sauyawa: = "."
Are ƙarshen

   Mun ƙare edita ta yin amfani da madaidaicin hanyar ta danna maɓallin rufewa a kusurwar dama ta sama.



3. Abu na gaba, zaɓi kewayon inda ya kamata a yi canjin. Latsa maballin Macroswanda dukkansu suna cikin rukunin kayan aikin guda ɗaya "Lambar".



4. Ana buɗe wata taga tare da jerin abubuwan macros da ke cikin littafin. Zaɓi wanda aka ƙirƙiri kwanan nan ta hanyar edita. Bayan munyi karin haske game da layi tare da sunanta, danna maballin Gudu.

Juyin juyi yana kan cigaba. Commas za a canza shi dige.

Darasi: Yadda ake ƙirƙirar macro a cikin Excel

Hanyar 4: Saitunan Excel

Hanya ta gaba ita ce kawai ta sama, wanda a yayin da ake juyar da wakafi zuwa dige, shirin zai san shi ne adadi, ba kamar rubutu ba. Don yin wannan, muna buƙatar canza tsarin mai raba tsarin a cikin saiti tare da wasannati zuwa zance.

1. Kasancewa a cikin shafin Fayiloli, danna sunan toshe "Zaɓuɓɓuka".



2. A cikin zaɓuɓɓukan window, matsa zuwa sashin "Ci gaba". Mun bincika toshe saitin Shirya Zaɓuka. Cire akwatin a kusa da darajar "Yi amfani da tsarin raba tsarin". Sannan a "Mai rarrabe abubuwa gaba ɗaya gyara tare da "," a kunne ".". Don shigar da sigogi, danna maɓallin "Ok".

Bayan matakan da ke sama, gwajin da aka yi amfani da shi azaman keɓaɓɓen gaɓoɓai zai juye zuwa maki. Amma, mafi mahimmanci, maganganun da aka yi amfani da su za su kasance na lamba, kuma ba za a canza su zuwa rubutu ba.

Akwai hanyoyi da yawa don sauya wakafi zuwa lokaci a cikin takardu na Excel. Yawancin waɗannan zaɓuɓɓukan sun haɗa da sauya tsarin bayanai daga adadi zuwa rubutu. Wannan yana haifar da gaskiyar cewa shirin ba zai iya amfani da waɗannan maganganun a cikin lissafin ba. Amma akwai kuma hanyar canza wakafi zuwa dige yayin da ake adana tsarin na asali. Don yin wannan, kuna buƙatar canza saitunan shirin kanta.