Yadda za a canza rufaffen cikin Forevicel: hanyoyi 3

Tare da canja wurin rikodin rubutu, masu amfani waɗanda suke aiki masu bincike, editocin rubutu da masu sarrafawa ana haɗuwa da su koyaushe. Koyaya, lokacin aiki a cikin tebur mai kyau mai kyau, irin wannan buƙatu ma iya faruwa, saboda wannan shirin ba kawai lambobin ba, har ma da rubutu. Bari mu tantance yadda ake canza encoding a cikin excele.

Darasi: M a Microsoft Word

Aiki tare da allon rubutu

Encoding rubutu - Wannan saitin maganganun dijital na lantarki da suka tuba zuwa waɗanda ke sanannun haruffan masu amfani. Akwai nau'ikan rufewa da yawa, kowane ɗayan yana da nasa ka'idodi da yare. Sanarwar shirin don sanin takamaiman yare kuma fassara shi ga waɗanda ke sanannun alamu (haruffa, lambobi, wasu haruffa) suna ƙayyade ko aikace-aikace zai iya yin aiki tare da takamaiman rubutu ko a'a. Daga cikin shahararrun rubutun rubutu ya kamata a kasafta su kamar haka:

• Windows-1251;
• Koi-8;
• ASCII;
• Anssi;
• Ubs-2;
• Utf-8 (Unicode).

Sunaye na ƙarshe shine mafi yawan gama gari tsakanin ƙasashe a cikin duniya, kamar yadda ake ganin wani nau'i ne na duniya.

Mafi sau da yawa, shirin da kanta ya fahimci encoding kuma yana sauya zuwa ta atomatik, amma a wasu lokuta da mai amfani yana buƙatar tantance bayyanar. Kawai sai kawai zai iya aiki daidai da alamomin lamba.

Excel yana da mafi yawan adadin matsalolin tabbatar da matsaloli tare da ingantaccen shirin lokacin da kuke ƙoƙarin buɗe fayilolin CSV ko fitarwa fayilolin fayil. Sau da yawa, maimakon haruffa na yau da kullun lokacin da ka buɗe waɗannan fayilolin ta farko, zamu iya lura da "crakozyabry". A cikin waɗannan halayen, mai amfani yana buƙatar yin wasu magiƙasa domin shirin fara nuna bayanai daidai. Akwai hanyoyi da yawa don warware wannan matsalar.

Hanyar 1: Canja rufaffen amfani da Notepad ++

Abin takaici, kayan cikakken kayan aiki wanda zai ba ku damar sauke bayanan da sauri a kowane nau'in rubutun daga Excel. Sabili da haka, ya zama dole a yi amfani da mafita matakan da yawa don waɗannan dalilai ko kuma su taimaka wa jam'iyya ta uku. Ofaya daga cikin hanyoyin ingantattun hanyoyin shine amfani da bayanin rubutu na rubutu edema ++.

1. Gudun aikace-aikacen Notepad +++. Danna kan fayil ɗin "fayil ɗin". Daga Jerin buɗewa, zabi abun "bude". A matsayin madadin, zaku iya buga lambar Ctrl + Onyboard akan keyboard.



2. Fayil ɗin buɗe taga yana farawa. Je zuwa directory inda takaddar ke zaune, wanda ba a ba daidai ba a cikin eathele. Muna haskaka shi kuma danna maɓallin "Open" a kasan taga.



3. Fayil yana buɗewa a cikin taga Editet edepad edeta edepad edeta edepad edeta. A kasan taga a gefen dama na kirjin matsayi ya nuna rikodin takaddar yanzu. Tunda Excellaysa yana nuna ba daidai ba, ana buƙatar yin canje-canje. Muna daukar Ctrl + haɗin haɗin maɓalli akan maɓallin maɓallin don haskaka duka rubutun. Latsa abu na menu na "lafazin". A cikin jerin da ke buɗe, zaɓi "sauya" sauya UTF-8 "abu. Wannan shine rufe Unicode kuma tare da nata ayyukan daidai.



4. Bayan haka, don adana canje-canje a cikin fayil ɗin ya buga maɓallin a kan kayan aiki a cikin hanyar faifan floppy disk. Rufe Notepad ++ ta danna maɓallin a matsayin farin giciye a cikin murabba'in ja a saman kusurwar dama na taga.



5. Bude fayil ɗin tare da daidaitaccen tsari ta hanyar shugaba ko amfani da wani zaɓi a cikin shirin Excel. Kamar yadda kake gani, ana nuna duk haruffa daidai.

Duk da cewa wannan hanyar ta dogara da software na ɓangare na uku, yana ɗayan zaɓuɓɓuka mafi sauƙi don fassara abubuwan da ke cikin fayilolin don Excel.

Hanyar 2: Aikace-aikacen Wizard

Bugu da kari, zaku iya sa canjinawa da amfani da kayan aikin shirye-shiryen, wato suttukan maganganu. Rashin isa, amfani da wannan kayan aiki ya fi rikitarwa fiye da amfani da shirin ɓangare na uku da aka bayyana a hanyar da ta gabata.

1. Gudanar da kyakkyawan shirin. Wajibi ne a kunna aikace-aikacen da kansa, kuma ba buɗe takaddar tare da shi ba. Wato, dole ne a bayyana blank takarda. Je zuwa shafin "bayanai". Latsa maɓallin akan tef ɗin "daga rubutun", sanya shi a cikin "Samun bayanai na waje" kayan aiki.



2. Window fayil ɗin taga yana buɗe. Yana goyan bayan buɗe abubuwan da ke gaba:
   • Txt;
   • CSV;
   • Prn.

   Je zuwa cikin directory don wurin da aka shigo da shi, zaɓi shi kuma danna maɓallin "shigo da".



3. Window Window taga yana buɗe. Kamar yadda muke gani, a cikin filin samfoti, ana nuna haruffan ba daidai ba ne. A cikin filin "Fayil", muna bayyana jerin zaɓuka kuma suna canza encoding zuwa "Unicode (UTF-8)" a ciki.

   

   Idan an nuna bayanan ta wata hanya, ba daidai ba ne, to, yi ƙoƙarin yin amfani da wasu iyakance har sai rubutun a cikin filin da ake kira. Bayan sakamakon ya gamsar da kai, danna maɓallin "Gaba".



4. Window mai zuwa Window mai zuwa yana buɗe. Anan zaka iya canja alamar mai rarrabawa, amma ana bada shawarar barin saitunan tsoho (alamar shafin). Latsa maɓallin "Gaba".



5. Tagan da ya gabata yana da ikon canza tsarin data shafi:
   • Janar;
   • Matani;
   • Ranar;
   • Tsallake shafi.

   Anan an saita saitunan, ba da yanayin abun ciki. Bayan haka, muna danna maɓallin "gama".



6. A cikin taga na gaba, saka daidaiton daidaitawar hagu na hagu na kewayon kewayon a kan akwatin inda aka saka bayanai. Za'a iya yin wannan ta hanyar tuki adireshin da hannu cikin filin da ya dace ko kawai haskaka sel da ake so a kan takardar. Bayan an ƙara masu daidaitawa, a cikin taga taga, danna "Ok" maɓallin.



7. Bayan haka, rubutun zai bayyana a kan takardar a cikin ubangijin da muke buƙata. Ya rage don tsara shi ko mayar da tsarin tebur, idan an lalata bayanan tabulur, kamar yadda aka lalata lokacin da sake fasalin.

Hanyar 3: Adana fayil a cikin takamaiman allon

Hakanan akwai wani yanayi na baya lokacin da dole ne a buɗe fayil ɗin tare da nuna daidai bayanai, kuma adana a cikin shigar da aka saka. Areo Excel, zaka iya aiwatar da wannan aikin.

1. Je zuwa shafin "fayil". Danna "Ajiye AS".



2. Dubai mai adana takardu ya buɗe. Ta amfani da mai kula da mai kula, muna bayyana directory inda za'a adana fayil ɗin. Sa'an nan kuma saita nau'in fayil idan muna son adana littafin a cikin tsari daban-daban daga matakin daidaitaccen tsarin (XLSX). Sannan na danna maballin "sabis" da kuma a cikin jerin da suka buɗe, zaɓi zaɓin "sigogin Yanar gizo".



3. A cikin taga da ke buɗewa, je zuwa shafin "eboding" shafin. A cikin "Ajiye Ajiye azaman" filin, buɗe jerin zaɓi kuma saita nau'in ɓoye daga jerin, waɗanda muke ganin ya zama dole. Bayan haka, danna maɓallin "Ok".
4. Komawa ga "daftarin ajiya Ajiye" taga kuma ga inda muke danna maballin "Ajiye".

Za a ajiye takaddar ta kan faifai mai wuya ko kafofin watsa labarai masu cirewa a cikin rufaffen da kuka gano. Amma kuna buƙatar la'akari da cewa yanzu koyaushe takardu da aka adana a Fink, ya sami ceto a cikin wannan encoding. Don canza wannan, dole ne ku je wurin "takaddar gidan yanar gizo" kuma canza saitunan.

Akwai wata hanya don canza saitunan rufaffiyar rubutu na cikin wannan rubutun.

1. Kasancewa a cikin "Fayil", danna "sigogi".



2. Window Excel taga yana buɗewa. Zabi Subparraph "Bugu da ƙari" daga jerin da ke kan gefen hagu na taga. Babban ɓangaren taga yana gungurawa zuwa "Janar" saiti. Anan danna kan "Saitunan shafin yanar gizo.



3. Saitin takardun takardun na yanar gizo "taga yana buɗewa, inda muke yin duk wannan ayyukan da suka yi magana a baya.

Yanzu duk takaddun da aka adana a Fore Excel zai kasance daidai da rufaffiyar da kuka shigar.

Kamar yadda kake gani, Excel bashi da kayan aiki wanda zai ba ka damar zuwa da sauri kuma a cikin sauya juyawa rubutu daga wanda ya zama ɗaya. Jagoran rubutu yana da ayyuka da yawa kuma yana da damar da ba su da mahimmanci don irin wannan hanyar. Amfani da shi, dole ne ku wuce fewan matakai, wanda kai tsaye kan wannan tsari baya tasiri, kuma ku bauta wa wasu dalilai. Hatta hira ta hanyar Edita na ɓangare na uku Notepad ++ a wannan yanayin ya yi kama da ɗan sauki. Adana fayiloli a cikin hanyar da aka bayar a aikace-aikacen Excel ma yana da rikitarwa da gaskiyar cewa duk lokacin da kuke so ku canza wannan siga, dole ne ku canza saitunan duniya na shirin.