Mutane masu amfani da Excel sun fuskanci tambaya na maye gurbin lokaci tare da rikici a cikin tebur. Wannan ya fi sau da yawa saboda gaskiyar cewa a cikin ƙasashen Ingilishi yana da al'adar raba rabi ƙayyadadden ƙira daga lamba ta ɗigon, da kuma a ƙasanmu - comma. Mafi mahimmanci, ba'a san lambobin da aka samu ba a cikin harsunan Rasha na Excel a matsayin maɓallin lambobi. Saboda haka, wannan shugabanci na maye gurbin yana da dacewa. Bari mu kwatanta yadda za a canza maki don faɗakarwa a cikin Microsoft Excel a hanyoyi masu yawa.
Hanyoyin da za a canza maɓallin zuwa wani lambobi
Akwai hanyoyi da yawa waɗanda aka gano don canja maƙallin zuwa wani lambobi a cikin shirin Excel. Wasu daga cikinsu an warware su tare da taimakon aikin wannan aikace-aikacen, kuma yin amfani da wasu yana buƙatar amfani da shirye-shiryen ɓangare na uku.
Hanyar 1: Nemi kuma Sauya kayan aiki
Hanyar mafi sauki don maye gurbin dige tare da ƙwaƙwalwar ƙafa shi ne ya dauki amfani da yiwuwar miƙa ta kayan aiki. "Nemi kuma maye gurbin". Amma, kuma tare da shi kana buƙatar nuna hali a hankali. Bayan haka, idan aka yi amfani da shi ba daidai ba, duk abin da ke cikin takardar za a maye gurbin, ko a cikin wuraren da ake bukata sosai, misali, a kwanakin. Saboda haka, wannan hanya dole ne a yi amfani da shi a hankali.
- Da yake cikin shafin "Gida"a cikin ƙungiyar kayan aiki Ana gyara a kan tef danna maballin "Nemi kuma haskaka". A cikin menu da ya bayyana, danna kan abu "Sauya".
- Window yana buɗe "Nemi kuma maye gurbin". A cikin filin "Nemi" saka alamar alamar (.). A cikin filin "Sauya" - Alamar sanarwa (,). Danna maballin "Zabuka".
- Bude ƙarin bincike kuma maye gurbin saituna. Matsayyar saɓani "Sauya da ..." danna maballin "Tsarin".
- Ginin yana buɗewa wanda zamu iya tsara tsarin tantanin tantanin halitta, duk abin da ya kasance a baya. A cikin yanayinmu, babban abu shine a saita tsarin jigilar lambobi. A cikin shafin "Lambar" daga cikin jeri na samfurori masu yawa zaɓi abu "Numeric". Muna danna maɓallin "Ok".
- Bayan mun koma taga "Nemi kuma maye gurbin", zaɓi dukan sassan kwayoyin a kan takardar, inda kake buƙatar yin wani wuri mai sauya ta hanyar wakafi. Wannan yana da mahimmanci, domin idan ba ku zaɓi wani kewayon ba, to, maye gurbin zai faru a kan dukkan takardun, wanda ba dole ba ne a kowane lokaci. Sa'an nan, danna maballin "Sauya Duk".
Kamar yadda kake gani, maye gurbin ya ci nasara.
Darasi: maye gurbin haruffa a Excel
Hanyar 2: Yi amfani da aikin SUB
Wani zaɓi don maye gurbin matsala tare da takaddama shine amfani da FIT aiki. Duk da haka, yayin yin amfani da wannan aikin, maye gurbin baya faruwa a cikin sassan Kayan jiki, amma ana nuna shi a cikin wani shafi na dabam.
- Zaɓi tantanin halitta wanda zai zama farkon a cikin shafi don nuna bayanan da aka canja. Danna maballin "Saka aiki"wanda aka je gefen hagu na wuri na aikin layi.
- Ya fara aikin mai aiki. A cikin jerin da aka gabatar a bude taga, muna neman aikin SUBMIT. Zaɓi shi kuma danna maballin. "Ok".
- An kunna maɓallin maganin aikin. A cikin filin "Rubutu" kana buƙatar shigar da saitunan farkon tantanin halitta na shafi inda aka sami lambobi tare da dots. Ana iya yin haka ta hanyar zabar wannan tantanin halitta akan takardar tare da linzamin kwamfuta. A cikin filin "Star_text" saka maɓallin (.). A cikin filin "New_text" sanya comma (,). Field "Lambar shigarwa" babu buƙatar cika. Ayyukan da kanta za su kasance suna da alaƙa kamar haka: "= SUB (adireshin cell;"; ";", ",", ")". Muna danna maɓallin "Ok".
- Kamar yadda kake gani, a cikin sabon tantanin halitta, lambar da ta riga tana da takamaimai maimakon wani abu. Yanzu muna bukatar mu yi irin wannan aikin don dukkan sauran kwayoyin cikin shafi. Tabbas, baku buƙatar shigar da aiki don kowace lambar; akwai hanya mafi sauri don yin fasalin. Mun zama a gefen dama na tantanin halitta wanda ya ƙunshi bayanan da aka canza. Alamar cika alama ta bayyana. Riƙe maɓallin linzamin hagu, ja shi zuwa ƙananan iyakar yankin da ke dauke da bayanan da za a canza.
- Yanzu muna buƙatar sanya sassan cikin jerin lambobi. Zaɓi dukan yanki na bayanan da aka canza. A shafin ribbon "Gida" neman allon kayan aiki "Lambar". A cikin jerin layi, mun canza tsarin zuwa numfashi.
Wannan ya kammala fassarar bayanai.
Hanyar 3: Yi amfani da Macro
Hakanan zaka iya maye gurbin lokacin tare da wakafi a Excel ta amfani da macro.
- Da farko, kana buƙatar taimaka macros da shafin "Developer"idan ba a haɗa su ba.
- Jeka shafin "Developer".
- Muna danna maɓallin "Kayayyakin Gida".
- Saka da wadannan shafuka zuwa cikin editan edita:
Sub Macro_substitution_complete ()
Selection.Replace Abin da: = ".", Sauyawa: = ","
Ƙarshen subRufe edita.
- Zaɓi yanki na sel a kan takardar da kake son juyawa. A cikin shafin "Developer" danna maballin Macros.
- A cikin taga wanda ya buɗe, jerin macros. Zaɓi daga jerin "Macro maye gurbin takamaimai don maki". Muna danna maɓallin Gudun.
Bayan haka, ana mayar da maki zuwa lambobi a cikin jinsunan da aka zaɓa na sel.
Hankali! Yi amfani da wannan hanya sosai a hankali. Ayyukan wannan macro ba su da kariya, don haka zaɓi waɗannan sassan da kake son amfani da ita.
Darasi: yadda za a ƙirƙiri macro a cikin Microsoft Excel
Hanyar 4: Yi amfani da Ƙambar rubutu
Hanyar da ake biyowa ta shafi yin kwafin bayanai zuwa cikin editan rubutu na Windows Notepad, da kuma canza su a cikin wannan shirin.
- Zaɓi a Excel yankin na sel wanda kake son maye gurbin matsala tare da wakafi. Danna maballin linzamin dama. A cikin mahallin menu, zaɓi abu "Kwafi".
- Bude Rubutun. Yi dannawa tare da maɓallin linzamin linzamin dama, kuma a cikin jerin da ke nuna danna abu Manna.
- Danna maɓallin menu Shirya. A cikin jerin da aka bayyana, zaɓi abu "Sauya". A madadin, za ka iya kawai rubuta maɓallin haɗin haɗin kan keyboard Ctrl + H.
- Bincike da maye gurbin taga ya buɗe. A cikin filin "Me" kawo ƙarshen. A cikin filin "Me" - wakafi. Muna danna maɓallin "Sauya Duk".
- Zaɓi abubuwan da aka gyara a Notepad. Danna maɓallin linzamin linzamin dama, kuma a cikin jerin zaɓin abu "Kwafi". Ko kuma danna kan hanyar gajeren hanya Ctrl + C.
- Muna komawa zuwa Excel. Zaži kewayon sel inda za'a maye gurbin dabi'u. Mun danna kan shi tare da maɓallin dama. A cikin menu wanda ya bayyana a cikin sashe "Zaɓuɓɓukan Zaɓuka" danna maballin "Ajiye rubutu kawai". Ko, latsa maɓallin haɗin Ctrl + V.
- Don dukan jigilar sel, saita tsarin lambobi a daidai wannan hanya kamar yadda a baya.
Hanyar 5: Canja Saitunan Sauti
A matsayin daya daga cikin hanyoyin da za a juyo maki zuwa lambobin yabo, zaka iya amfani da saitunan gyare-gyare na Excel.
- Jeka shafin "Fayil".
- Zaɓi wani ɓangare "Zabuka".
- Je zuwa maƙallin "Advanced".
- A cikin saitunan sashe "Shirya zažužžukan" cire kayan "Yi amfani da tsarin delimiters". A filin da aka kunna "Zane-zane na ɓangaren duka da rabi" kawo ƙarshen. Muna danna maɓallin "Ok".
- Amma, bayanai kanta ba zai canza ba. Muna kwafe su a cikin Ɗab'in Ƙaƙwalwar ajiya, sa'an nan kuma manna su a cikin wannan wuri a cikin hanyar da ta saba.
- Bayan an gama aiki, an bada shawarar komawa da saitunan tsoho na Excel.
Hanyar 6: sauya tsarin saituna
Wannan hanya tana kama da na baya. Sai kawai wannan lokaci, baza mu canza saitunan Excel ba. Kuma tsarin saitunan Windows.
- Ta hanyar menu "Fara" mun shiga "Hanyar sarrafawa".
- A cikin Sarrafa Sarrafa, je zuwa sashe "Clock, harshe da yanki".
- Je zuwa sashi na sashe "Tsarin Harshe da Yanayi".
- A cikin bude taga a shafin "Formats" danna maballin "Tsarin Saitunan".
- A cikin filin "Zane-zane na ɓangaren duka da rabi" mun canza takaddama don ma'ana. Muna danna maɓallin "Ok".
- Kwafi bayanai ta hanyar Ɗabutun zuwa Excel.
- Mu dawo da saitunan Windows na baya.
Abu na karshe yana da matukar muhimmanci. Idan ba ku kashe shi ba, baza ku iya yin fasalin lissafi ba tare da bayanan da aka canza. Bugu da ƙari, wasu shirye-shirye da aka sanya a kan kwamfutar sun iya aiki daidai ba.
Kamar yadda kake gani, akwai hanyoyi da dama don maye gurbin tasha tare da takaddama a Microsoft Excel. Hakika, mafi yawan masu amfani sun fi so su yi amfani da kayan aiki mafi sauki kuma mafi dacewa saboda wannan hanya. "Nemi kuma maye gurbin". Amma, da rashin alheri, a wasu lokuta tare da taimakonsa baza'a iya canza bayanin daidai ba. Wannan shine lokacin da sauran mafita zasu iya zuwa wurin ceto.
