Yenza i-random password generator kwi-Excel ngeefomyula

Ukwenza iiphasiwedi ezinamandla ngokuthe ngqo kwi-Excel kulula kunokuba kubonakala.Ngemisebenzi embalwa kunye nobukrelekrele obuncinci, unokuvelisa amagama ayimfihlo angaqhelekanga adibanisa iileta, amanani, kunye neesimboli ngaphandle kokufaka enye into. Ukuba ufuna iifomati ezithile, ezinje ngoonobumba ababini, amanani amane, kunye noonobumba ababini abangakumbi, unokwenza oku ngokuzenzekela ngeefomula.

Kwesi sikhokelo uya kufumana isishwankathelo esipheleleyo weendlela: ukusuka ekusebenziseni imisebenzi elinganayo yeSpanish kunye nesiNgesi ye-Excel (i-CHAR kunye ne-RANDBETWEEN), kumzekelo osebenzayo weeleta ezi-2 + iinombolo ezi-4 + iileta ezi-2, ukudala iiphasiwedi ezineempawu, enye indlela ekhawulezayo yeephasiwedi zamanani kuphela, kunye nendlela yokwenza ngayo nge-Kutools '"Faka iDatha eRandom" isixhobo. Sikwajonga kwakhona ukuba kutheni ingumbono olungileyo ukusebenzisa amagama ayimfihlo aqinileyo kunye nendlela yokuphepha iimpazamo eziqhelekileyo.

Amagama aphambili: Iikhowudi ze-ASCII kunye nemisebenzi oza kuyisebenzisa

Ukuvelisa iimpawu ukusuka kumanani kwi-Excel sithembele kwitheyibhile ye-ASCII. Umlinganiswa ngamnye unenombolo ehambelanayo phakathi kuka-1 no-255; umzekelo, ama-48 ukuya kuma-57 ngoonobumba abakhulu ukusuka ku-0 ukuya ku-9, ama-65 ukuya kuma-90 ngoonobumba abakhulu A–Z, kunye no-97 ukuya ku-122 ngoonobumba abancinane a–z. Oku kuvumela "buza" oonobumba okanye amanani abonisa uluhlu lwamanani.

Umsebenzi we-CHAR (okanye CHAR kwi-Excel) ubuyisela isimboli sekhowudi oyidlulisela kuyo.. Ukuba ufuna ukubona imbalelwano epheleleyo, yenza ikholamu enamanani ukusuka ku-1 ukuya ku-255 (umzekelo, ku-N1 ukuya ezantsi) kwaye kwi-M1 bhala. =CARACTER(N1); tsala phantsi kwaye uya kuba netafile kwindawo. Njengomdla wokwazi, kwi Windows Ungachwetheza umlinganiswa nge-Alt + ikhowudi yamanani.

Ukufumana amanani angaqhelekanga ngexesha lokuphumla sisebenzisa i-RANDBETWEEN. Umzekelo =ALEATORIO.ENTRE(1;100) ibuyisela inani elipheleleyo phakathi ko-1 kunye ne-100. Esi sisiseko sokukhetha, ngelothari, nawuphi na unobumba, inombolo okanye isimboli ekhomba kuluhlu oluchanekileyo lwe-ASCII.

Ukuba awuboni RANDOM.PHAKATHI kudidi lweMathematika (into eyenzekayo kwiinguqulelo ezindala), yivule ngokuya ku Izixhobo> Iiplagi kunye nokumakishwa Izixhobo zokuhlalutyaNje ukuba yenziwe, umsebenzi uya kuvela kwi-Excel yakho.

Yenza isitshixo ngefomathi 2 oonobumba + 4 amanani + 2 oonobumba

Imeko yeklasiki yenza amagama ayimfihlo ngepateni esisigxinaKhawucinge ukuba ufuna oonobumba ababini kanye ekuqaleni, amanani amane embindini, kunye noonobumba ababini ekupheleni. Ngolungiselelo oluncinci kunye neefomyula ezilula, uya kuzifumana kwimizuzu.

Okokuqala, chaza uluhlu lwe-ASCII oza kulisebenzisa. Kwiseli ye-E5, thayipha i-48 kunye ne-F5, thayipha i-57 (amanani 0 nge-9). Kwi-E6, thayipha i-65 kunye ne-F6, thayipha i-90 (iileta A-Z). Ngale ndlela, unokubhekisa le mida ngaphandle kokuchwetheza ngexesha ngalinye.

Yenza oonobumba abangaqhelekanga kwiiseli ezizimeleyo. Kwi-E2 faka: =CARACTER(ALEATORIO.ENTRE($E$6;$F$6)). Khuphela kwaloo fomula inye ku-D2, K2, kunye no-L2 ukuquka oonobumba bokuqala ababini nababini bokugqibela. Ngamnye uya kubuya unobumba omkhulu ongacwangciswanga.

Ngoku yenza amanani amane aphakathi. Kwi-G2 bhala: =CARACTER(ALEATORIO.ENTRE($E$5;$F$5)) kwaye tsala ngasekunene ku-J2. Uya kufumana abalinganiswa abane bamanani angaqhelekanga (0–9).

Idibanisa ukwenza igama lokugqitha kwiseli enyeKwi-B2 ungadibanisa yonke into nge & nomsebenzisi: =E2&F2&G2&H2&I2&J2&K2&L2. Ukuba ukhetha ifomula enye kuyo, yithi, B4, ungayiqamba ngokudibanisa iminxeba ukuya kwi-CHAR + RANDBETWEEN yecandelo ngalinye: =CARACTER(ALEATORIO.ENTRE($E$6;$F$6))&CARACTER(ALEATORIO.ENTRE($E$6;$F$6))&CARACTER(ALEATORIO.ENTRE($E$5;$F$5))&CARACTER(ALEATORIO.ENTRE($E$5;$F$5))&CARACTER(ALEATORIO.ENTRE($E$5;$F$5))&CARACTER(ALEATORIO.ENTRE($E$5;$F$5))&CARACTER(ALEATORIO.ENTRE($E$6;$F$6))&CARACTER(ALEATORIO.ENTRE($E$6;$F$6)).

Ngalo lonke ixesha i-Excel ibala kwakhona, iqhosha liyatshintshaCofa u-F9 ukunyanzela umzobo omtsha. Ukuba ufuna ukumisa igama eligqithisiweyo elenziwe, khuphela iseli kwaye uyincamathisele njengamaxabiso ukuze iyeke ukuhlaziya ngokubala kwakhona.

Amagama okugqithisa adibanisa oonobumba abakhulu, abancinci, amanani kunye neesimboli

Ukuba imigaqo-nkqubo yakho yokhuseleko ifuna iindidi ezahlukeneyo zabalinganiswa (oonobumba abakhulu, abancinci, abancinci kunye nabalinganiswa abakhethekileyo), ungakha igama eligqithisiweyo lendawo yesi-8 ngokudibanisa uluhlu olufanelekileyo lwe-ASCII.

Kwi-Excel ngeSpanish Ungasebenzisa ifomula efana nale, ebuyisela oonobumba abakhulu aba-2, oonobumba abancinci aba-2, amanani ama-2, kunye neesimboli ezi-2 ezikhethekileyo: =CARACTER(ALEATORIO.ENTRE(65;90))&CARACTER(ALEATORIO.ENTRE(97;122))&3;CARACTER(ALEATORIO.ENTRE(48;57))&CARACTER(ALEATORIO.ENTRE(33;47))&CARACTER(ALEATORIO.ENTRE(65;90))&CARACTER(ALEATORIO.ENTRE(97;122))&3;CARACTER(ALEATORIO.ENTRE(48;57))&CARACTER(ALEATORIO.ENTRE(58;64)). Ukufumana ireferensi ebonakalayo yoluhlu, ndwendwela isifundo sethu Lawula amagama agqithisiweyo agciniweyo kwi-Edge.

Ukuba i-Excel yakho ibhalwe ngesiNgesi, ifom elinganayo ne-CHAR kunye ne-RANDBETWEEN iya kuba: =CHAR(RANDBETWEEN(65,90))&CHAR(RANDBETWEEN(97,122))&RANDBETWEEN(48,57)&RANDBETWEEN(33,47)&CHAR(RANDBETWEEN(65,90))&CHAR(RANDBETWEEN(97,122))&RANDBETWEEN(48,57)&RANDBETWEEN(58,64))Ukuze ufumane inkcazelo engakumbi, nceda ujonge kwakhona inqaku lethu Nqanda iibhrawuza ekukhumbuleni amagama ayimfihlo.

Yintoni eyenziwa licandelo ngalinye:

• 65-90: unobumba omkhulu ongacwangciswanga (A–Z).
• 97-122: unobumba omncinci ongaqhelekanga (a–z).
• 48-57: idijithi engacwangciswanga (0–9).
• 33–47 kunye nama-58–64: iimpawu ezikhethekileyo ezifana !, «, #, $, %, &, ', (, ), *, +, , , -, ., /, :, ;, <, =, >, ?, @, njl.

Lungiselela ubude kunye nokusabalalisa ukulungelelanisa ukuba uphinda kangaphi ibhloko nganye kunye nolandelelwano oluvela ngalo. Ukugrumba nzulu kukhuseleko lweephasiwedi zakho, jonga isifundo sethu iinkqubo brute amandla ukuqhekeza amagama agqithisiweyo.

Khumbula ukuba ezi fomula zibalwe ngokutshaUkugcina iqhosha elithile, khuphela iseli kwaye uyincamathisele njengamaxabiso. Unako kwakhona ukutshintsha indlela yokubala kwi-manual ukuba uvelisa iibhetshi ezinkulu kwaye awufuni ukuba zitshintshe de wenze isigqibo.

Amagama okugqithisa amanani kuphela (akhawulezayo kwaye angenangxaki)

Ukuba into oyifunayo liqhosha lamanani lobude obusisigxina, ungasebenzisa uluhlu. Umzekelo, kumanani asi-8: kwi-Excel ngesiNgesi yenza amagama agqithisiweyo kwikhonsoli yeWindows kunye nefomula =RANDBETWEEN(10000000,99999999), nangeSpanish =ALEATORIO.ENTRE(10000000;99999999). Ifomula iyakubuyisela inani elinamanani asibhozo.

Qaphela ngooziro abakhokelayoUkuba nayiphi na indibaniselwano enoziro onokubakhona ilungile, inketho enye yile: =TEXTO(ALEATORIO.ENTRE(0;99999999);"00000000")Oku kuqinisekisa ukuba umphumo uya kuhlala unamanani angama-8, nokuba iqala ngo-0. Ukulawula amagama ayimfihlo agciniweyo, unokujonga isifundo sethu.

I-Kutools ye-Excel: Yenza iiPasswords kwiiNqakrazo ezimbalwa

Ukuba ukhetha isisombululo esine-interface elula kwaye ngaphandle kweefomulaI-Kutools ye-Excel inikezela nge-"Faka i-Random Data" i-utility eyenza ii-password eziyinkimbinkimbi ngokukhetha iintlobo zeempawu kunye nobude.

Indlela yokwenza ngayo:

1. Khetha uluhlu apho ufuna ukufaka khona amagama agqithisiweyo kunye nokufikelela I-Kutools> Faka> Faka i-Random Data.
2. Kwi Chain thebhu, phawula iindidi zamagama owafunayo (oonobumba abakhulu, abancinci, amanani, iisimboli) kwaye uchaze ubude bekhonkco.
3. Cofa uYamkela kwaye iiseli ziya kuzaliswa ngokuzenzekelayo ngamaphasiwedi azinzileyo (angatshintshiyo xa elungiswa okanye elayishwa kwakhona).

Olu ncedo lunceda neminye imisebenzi: Faka amanani angaqhelekanga, imihla, amaxesha, okanye uluhlu lwesiko, udala idatha yovavanyo olwahlukeneyo ngomzamo omncinci.

Yintoni i-password generator kwaye kutheni kufuneka uyisebenzise?

I-password generator yenza izitshixo ngokuzenzekelayo imigaqo elandelayo oyikhethayo (umzekelo, kubandakanywa iimpawu, i-capitalization, ubude obuncinane, njl.). Yindlela esebenzayo yokuqinisekisa ukhuseleko oluluqilima lwedijithali ngokulawula ukungakhethi ngokweemfuno zakho.

Ukusebenzisa amagama ayimfihlo awomeleleyo kubalulekileUkuphinda usebenzise igama eliyimfihlo kwiinkonzo ezininzi kubeka umngcipheko omkhulu: ukuba umntu uyayifumana, unokufikelela kwiiakhawunti ezininzi. Ngaphaya koko, kukho indibaniselwano eqikelelwayo kwaye esengozini efana ne-123456, iPassword, 1111, qwerty, okanye i-admin ekufuneka isoloko iphetshwa.

Ukuququzelela ulawulo, kukho iitemplates ezithi, ngojongano olulula, zikuvumela ukuba wenze amagama ayimfihlo alungelelaniswe nemigaqo-nkqubo ethile yombutho ngamnye, iququzelela iyunifomu kunye nolawulo olusebenzayo.

Iingcebiso ezisebenzayo kunye neendlela ezifanelekileyo zokuvelisa amagama ayimfihlo kwi-Excel

Ukunqanda ukuphulukana nephasiwedi yakho eyenziweyoNje ukuba unazo, zikope kwaye uzincamathisele njengamaxabiso ukuthintela ukutshintsha xa ubala kwakhona. Oku kuqinisekisa ukuba igama lokugqitha lihlala lingatshintshwanga, ngaphandle kokuguqulwa ngempazamo.

Ukuphucula ukhuseleko ngokuxuba umyaleloNokuba usebenzisa amacandelo athile kwipateni, ungawahlenga-hlengisa okanye uwatshixise usebenzisa uhlenga-hlengiso okanye imisebenzi ye-randomization, ukwenza iipateni zibenzima ngakumbi kunye nokwandisa i-entropy.

Jonga ukuntsokotha. Qinisekisa ukuba iifomula zakho ziyahlangabezana neemfuno zokuba nonobumba omnye ubuncinane kuhlobo ngalunye (oonobumba abakhulu, abancinane, isimboli, inombolo) ngokwemigaqo-nkqubo yokusingqongileyo.

Yenza i-plugin yohlalutyo ukuba i-RANDBETWEEN ayikho. Kufakelo oludala, yiya ku Izixhobo> Iiplagi kunye negama Izixhobo zokuhlalutya. Eli nqaku liza kufumaneka kudidi lweMathematika.

Velisa izixa ezikhulu ngokulula. Sebenzisa isiphatho sokuzalisa ukukopa iifomula phantsi kwaye wenze amagama agqithisiweyo amaninzi ngexesha elinye. Nge-Kutools, khetha ngokulula kwaye ugcwalise yonke into ngamanyathelo akhawulezayo.

Ukulingana komsebenzi (I-Excel ngeSpanish vs. IsiNgesi)

Ukuba usebenza kwiinguqulelo zolwimi ezahlukeneyo ze-Excel, khumbula ukuba UMNTU = UMHLABA y RANDBETWEEN = RANDBETWEENNgeSpanish, iingxoxo zisebenzisa i<em>semicolon (;), ngesiNgesi, iikoma (,).

ASCII izintlu zezitshixo zamagama agqithisiweyo Amagama okugqithisa anomtya wephasiwedi afana no-48–57 (amanani), 65–90 (onobumba abakhulu), 97–122 (oonobumba abancinane), kunye neentambo zesimboli ezifana no-33–47 no-58–64 zibalulekile ekudaleni amagama ayimfihlo aqinileyo nezahlukeneyo. Ungazihlengahlengisa ngokwepolisi yakho yangaphakathi.

Gqibezela imizekelo elungele ukukopa

2 Oonobumba + 4 Amanani + 2 Iipateni zoonobumba kwi-Excel kwiSpanish: Kwisampulu yefomula kwi-B4, bhala: =CARACTER(ALEATORIO.ENTRE(65;90))&CARACTER(ALEATORIO.ENTRE(65;90))&CARACTER(ALEATORIO.ENTRE(48;57))&CARACTER(ALEATORIO.ENTRE(48;57))&CARACTER(ALEATORIO.ENTRE(48;57))&CARACTER(ALEATORIO.ENTRE(48;57))&CARACTER(ALEATORIO.ENTRE(65;90))&CARACTER(ALEATORIO.ENTRE(65;90)).

I-Mixed password yedijithi ezisi-8 ezinesimboli kwi-Excel kwisiNgesi: =CHAR(RANDBETWEEN(65,90))&CHAR(RANDBETWEEN(97,122))&RANDBETWEEN(48,57)&RANDBETWEEN(33,47)&CHAR(RANDBETWEEN(65,90))&CHAR(RANDBETWEEN(97,122))&RANDBETWEEN(48,57)&RANDBETWEEN(58,64))Ukuba i-Excel yakho ikwiSpanish, buyisela i-CHAR nge-CHARACTER kunye ne-RANDBETWEEN nge-RAndoM.BETWEEN, usebenzisa isemicolon njengomahluli.

Amanani anamanani asi-8 kuphela: ngeSpanish =ALEATORIO.ENTRE(10000000;99999999), ngesiNgesi =RANDBETWEEN(10000000,99999999). Ukubandakanya ooziro abakhokelayo, sebenzisa =TEXTO(ALEATORIO.ENTRE(0;99999999);"00000000"). Ukuphucula ngakumbi ulawulo lwakho lokugqitha, ungajonga isifundo sethu Lawula iiadaptha zenethiwekhi ezinenyani kwiWindows.

Khumbula: Yakha iitafile nge =CARACTER(N1) ukujonga ukuba ngabaphi abalinganiswa abahambelana nekhowudi nganye, ukunceda ukulungisa uluhlu olufunekayo kunye neempawu.

Ngayo yonke le nto, uneseti ebanzi yeenketho ukwenza iiphasiwedi kwi-Excel: ukusuka kwiipatheni eziqingqiweyo ukuya kwiintlobo ezahlukeneyo zokudibanisa kunye neeleta, amanani, iimpawu, kunye nobude obuhlukeneyo, usebenzisa iifomyula okanye izixhobo ezincedisayo ezifana ne-Kutools; ukuziqhelanisa neemfuno zakho zokhuseleko.

Inqaku elidibeneyo:

Uzikhusela njani izikhangeli zewebhu ekukhumbuleni amagama ayimfihlo akho

UIsake

Umbhali onomdla malunga nehlabathi le-bytes kunye netekhnoloji ngokubanzi. Ndiyakuthanda ukwabelana ngolwazi lwam ngokubhala, kwaye yile nto ndiza kuyenza kule bhlog, ndikubonise zonke izinto ezinomdla malunga nezixhobo, isoftware, ihardware, iindlela zetekhnoloji, kunye nokunye. Injongo yam kukukunceda uhambe kwihlabathi ledijithali ngendlela elula neyonwabisayo.