Canza lamba a Microsoft Excel

Buƙatar sauya ɓoye rubutun shine mafi yawan lokuta masu amfani da masu bincike ke aiki, masu rubutun rubutu da masu sarrafawa. Koyaya, lokacin aiki a cikin babbar ingin gidan watsa labarai na Excel, irin wannan buƙatar na iya tashi, saboda wannan shirin yana aiwatar da lambobi ba kawai ba, har ma da rubutu. Bari mu ga yadda za a sauya yadda ake sarrafa a Excel.

Darasi: Shigar da rubutu a cikin Microsoft Word

Aiki tare da rubutun

Ru'yashe rubutu wani saiti ne na maganganun dijital na lantarki wanda aka canza shi zuwa haruffan masu amfani. Akwai ire-iren tsari iri-iri, kowannensu na da ka'idodi da yare. Ikon shirin don gane takamaiman yare da fassara shi cikin alamun da ke da fahimta ga talakawa (haruffa, lambobi, wasu alamomi) sun ƙayyade ko aikace-aikacen na iya aiki tare da takamaiman rubutu ko a'a. Daga cikin sanannun bayanan rubutun akwai:

• Windows-1251;
• KOI-8;
• ASCII;
• ANSI
• UKS-2;
• UTF-8 (Unicode).

Sunan ta karshen shine ya zama ruwan dare gama gari tsakanin duniya, tunda ana daukarta wani nau'in daidaitaccen tsari ne na duniya.

Mafi sau da yawa, shirin da kansa yana fahimtar ɓoye bayanan kuma yana juyawa zuwa gare ta ta atomatik, amma a wasu lokuta mai amfani yana buƙatar gaya wa aikace-aikacen bayyanar. Hakan ne kawai zai iya yin aiki daidai tare da haruffan rikodi.

Excel yana haɗuwa da lambar mafi yawan matsalolin ɓoye ƙira yayin ƙoƙarin buɗe fayilolin CSV ko fayilolin txt. Sau da yawa, maimakon haruffa na yau da kullun lokacin buɗe waɗannan fayiloli ta hanyar Excel, zamu iya lura da baƙon haruffa, abin da ake kira "krakozyabry". A waɗannan halayen, mai amfani yana buƙatar yin wasu jan hankali don shirin ya fara nuna bayanai daidai. Akwai hanyoyi da yawa don magance wannan matsalar.

Hanyar 1: canza bayanan ta amfani da Notepad ++

Abun takaici, Excel bashi da cikakkiyar kayan aiki wanda zai baka damar canza rubutun cikin sauri a kowane nau'in rubutu. Don haka, dole ne mutum ya yi amfani da hanyoyin da yawa na matakai don waɗannan dalilai ko neman taimakon aikace-aikace na ɓangare na uku. Daya daga cikin hanyoyin ingantattu shine a yi amfani da Rubutun rubutu ++.

1. Mun ƙaddamar da aikace-aikacen Notepad ++. Danna kan kayan Fayiloli. Daga jeri dake buɗe, zaɓi "Bude". A madadin haka, zaku iya buga gajerar hanyar rubutu akan maballin Ctrl + O.



2. Fayil bude taga yana farawa. Mun je inda shugabanin yake, wanda ba a nuna shi ba a cikin Excel. Zaɓi shi kuma danna maballin. "Bude" a kasan taga.



3. Fayil yana buɗewa a cikin editan windowpad ++. A ƙasan taga a gefen dama na sandar halin ɓoye ne yanzu. Tun da Excel ba ya nuna shi daidai, ana buƙatar canje-canje. Mun buga hade makullin Ctrl + A kan maɓallin rubutu don zaɓar duk rubutu. Danna kan abun menu "Rufe bayanan". Cikin jeri dake buɗe, zaɓi Canza zuwa UTF-8. Wannan hanyar Unicode ce kuma Excel tayi aiki tare dashi gwargwadon iko.



4. Bayan haka, don adana canje-canje ga fayil ɗin, danna maballin a kan kayan aikin ta hanyar diskette. Rufe bayanin kula ++ ta danna maɓallin a cikin hanyar farin gicciye a cikin wani murabba'in jan a cikin kusurwar dama ta sama na taga.



5. Mun buɗe fayil ɗin a hanya madaidaiciya ta mai binciken ko amfani da wani zaɓi a cikin Excel. Kamar yadda kake gani, duk haruffan yanzu an nuna su daidai.

Duk da cewa wannan hanyar ta samo asali ne daga amfani da kayan aiki na ɓangare na uku, yana ɗaya daga cikin zaɓuɓɓuka mafi sauƙi don canza abubuwan cikin fayiloli zuwa Excel.

Hanyar 2: amfani da Wizard Text

Bugu da kari, zaku iya aiwatar da juyawa ta amfani da kayan aikin ginanniyar shirin, shine Mayen Rubutu. Abin takaici, amfani da wannan kayan aiki ya fi rikitarwa fiye da amfani da shirin ɓangare na uku wanda aka bayyana a cikin hanyar da ta gabata.

1. Mun fara shirin Excel. Wajibi ne don kunna aikace-aikacen kanta, kuma kada ku buɗe takaddar tare da taimakonta. Wato, takardar blank yakamata ya bayyana a gabanka. Je zuwa shafin "Bayanai". Danna maballin akan kintinkiri "Daga rubutun"sanya a cikin kayan aiki "Samun bayanan waje".



2. Window ɗin shigo da rubutu yake buɗe. Yana tallafawa buɗewar waɗannan tsarukan:
   • Txt;
   • CSV;
   • PRN.

   Je zuwa wurin shugabanci na inda fayil ɗin da aka shigo da shi, zaɓi shi kuma danna maballin "Shigo".



3. Window ɗin Wizard ɗin yana buɗewa. Kamar yadda kake gani, a cikin samfotin filin ana nuna haruffa ba daidai ba. A fagen "Tsarin fayil" bude Jerin sunaye sai ka canza lullubi a ciki Unicode (UTF-8).

   

   Idan har yanzu bayanan sun nuna ba daidai ba, to muna ƙoƙarin yin gwaji tare da amfani da wasu ɓoye bayanan har sai an karanta rubutun a cikin filin samfoti. Da zarar sakamakon ya gamsar da ku, danna kan maɓallin "Gaba".



4. Mai maye rubutun na gaba yana buɗewa. Anan zaka iya canza yanayin silan, amma an bada shawara don barin saitunan tsoho (shafin). Latsa maballin "Gaba".



5. A cikin taga na karshe, zaku iya sauya tsarin bayanan shafi:
   • Janar;
   • Rubutu
   • Kwanan Wata
   • Tsallake shafi.

   Anan ya kamata a saita saitunan, la'akari da yanayin abubuwan da aka sarrafa. Bayan haka, danna maɓallin Anyi.



6. A cikin taga na gaba, ƙayyade ayyukan daidaitawar hagu na sama na kewayon akan takardar inda za'a shigar da bayanai. Ana iya yin wannan ta hanyar fitar da adireshin da hannu a cikin filin da ya dace ko kuma kawai ta hanyar nuna alamar da ake so a jikin takardar. Bayan an ƙara masu gudanarwa, danna maballin a cikin taga "Ok".



7. Bayan haka, za a nuna rubutu a kan takardar a cikin bayanan da muke buƙata. Ya rage don tsara shi ko dawo da tsarin teburin, in da data kasance abin ƙoshi ne, tunda sake fasalin yana lalata shi.

Hanyar 3: ajiye fayil ɗin a cikin takamaiman ɓoye bayanan

Akwai halin da ake ciki lokacin da fayil ɗin baya buƙatar buɗe shi tare da allon bayanan daidai, amma an yi ajiyarsa cikin ingantaccen ɓoyayyun. A cikin Excel, zaku iya yin wannan aikin.

1. Je zuwa shafin Fayiloli. Danna kan kayan Ajiye As.



2. Window ɗin ajiya yana buɗe. Ta yin amfani da dubawa na Explorer, muna ƙayyade directory inda fayil ɗin za'a adana shi. Sa’annan mun saita nau'in fayil ɗin idan muna son adana littafin aikin a wani tsari daban da daidaitaccen tsarin Excel (xlsx). Sannan danna kan sigar "Sabis" kuma cikin jerin da zai buɗe, zaɓi Zabi Takardar Yanar Gizo.



3. A cikin taga wanda zai buɗe, je zuwa shafin "Lullube bayanan". A fagen Ajiye Takardar As bude jerin abubuwan da aka saukar kuma saita daga jerin nau'in rikodin da muke ganin ya zama dole. Bayan haka, danna maɓallin "Ok".



4. Komawa taga "Ajiye Takardar" sannan kuma danna maballin Ajiye.

Za a adana takaddun a kan babban rumbun kwamfutarka ko kuma hanyar cirewa ta cikin bayanan wanda kai kanka ka ƙaddara. Amma kuna buƙatar la'akari da cewa yanzu duk takaddun da aka ajiye a cikin Excel za a adana su a cikin wannan hanyar. Don canja wannan, dole ne ku sake zuwa taga Zabi Takardar Yanar Gizo kuma canza saitunan.

Akwai kuma wata hanyar sauya saiti rikodin rubutun da aka ajiye.

1. Kasancewa a cikin shafin Fayilolidanna kan kayan "Zaɓuɓɓuka".



2. Taga zabin na Excel yana buɗewa. Zabi sub "Ci gaba" daga jerin da ke gefen hagu na taga. Gungura ƙasa tsakiyar taga zuwa toshe saitin "Janar". Saika danna maballin Saitunan gidan yanar gizo.



3. Wani riga da muka saba da shi ya buɗe Zabi Takardar Yanar Gizo, inda muke yin duk matakan guda ɗaya waɗanda muka yi magana game da su a baya.



Yanzu duk wani takaddar da aka adana a cikin Excel zai sami ainihin bayanan da ka sanya.

Kamar yadda kake gani, Excel bashi da kayan aiki wanda zai baka damar juya rubutu da sauri kuma ya sauƙaƙe daga wannan ɓoye zuwa wani. Maballin rubutun yana da aiki mara kyau kuma yana da fasali da yawa waɗanda ba a buƙatar irin wannan hanyar. Amfani da shi, zaku sami matakai da yawa waɗanda basu shafi aikin wannan kai tsaye, amma suna aiki don wasu dalilai. Ko da juyawa ta hanyar rubutu na ɓangare na uku Notepad ++ a wannan yanayin yana ganin sauƙi kaɗan. Adana fayiloli a cikin bayanan da aka bayar a cikin Excel ma yana da rikitarwa ta gaskiyar cewa duk lokacin da kake son sauya wannan siga, dole ne ku canza saitunan duniya na shirin.

Share
Pin
Tweet
Send
Share
Send