Ke ʻimi nei i kahi ʻano ma kahi lālani pāpalapala Excel

ʻO nā mea hoʻohana Excel, ʻoiai ʻo ka loaʻa ʻana o ke ʻano i makemake ʻia e like me kahi hana maʻalahi, ʻaʻole maopopo pinepine pehea e hana ai. He maʻalahi kekahi o lākou, ʻoi aku ka paʻakikī o kekahi. Eia kekahi, i kekahi manawa aia nā pilikia me ka loaʻa ʻana o nā huaʻōlelo e like me ka hōʻailona nīnau a i ʻole kahi asterisk ma muli o ka hoʻohana ʻia ʻana i nā kānana. I kēia lā e wehewehe mākou i nā ala e loaʻa ai nā hōʻailona o nā ʻano like ʻole.

Pehea e ʻike ai i nā hua kikokikona (nā leka a me nā helu) i loko o ke kelepona

I ka hoʻomaka ʻana, e hoʻāʻo mākou e hana i ka hana maʻalahi: e hoʻoholo i ka hele ʻana o nā huaʻōlelo kikokikona i loko o nā cell a loaʻa i ka mea āu e pono ai. No ka hana ʻana i kēia, pono ʻoe e hoʻohana i ka !SEMTools add-on, kahi e hiki ai iā ʻoe ke ʻimi i nā huaʻōlelo o nā ʻano like ʻole. ʻO ke kaʻina o nā hana penei:

1. E koho i ka laula o ke kumu a kope ia i ke kolamu aʻe.
2. A laila koho i ka laulima lua.
3. E wehe i ka pā "! SEMTools". Ma laila, ma ka ʻaoʻao hema o ka hāmeʻa, aia kahi ʻaoʻao "Detect".
4. Ma hope o kēlā, wehe i ka papa kuhikuhi "Symbols".
5. A laila e ʻike ʻia kahi papa kuhikuhi hou, kahi e pono ai ʻoe e ʻimi i ka mea "Letters-Numbers" a kaomi iā ia.

Ma kēia animation, hiki iā ʻoe ke ʻike pono pehea e hoʻomau pololei ai i mea e ʻimi ai i nā huaʻōlelo kikokikona i loko o kahi keena. Me kēia hana hoʻohui, hiki i ka mea hoʻohana ke hoʻoholo inā he mau huaʻōlelo hiki ʻole ke paʻi ʻia i loko o nā pūnaewele ʻē aʻe.

Pehea e ʻike ai i nā helu ma ka pākaukau

I kekahi manawa pono ʻoe e ʻike i nā cell i loaʻa nā helu, akā aia me ka kikokikona. I ka nui o ia mau cell, hiki ke paʻakikī ke ʻike iā lākou. Ma mua o kou hoʻokō ʻana i kēia hana, pono ʻoe e wehewehe i kekahi mau huaʻōlelo kumu. ʻO kā mākou manaʻo nui he "ʻike". ʻO ia ke ʻano e nānā inā aia kekahi ʻano ʻano i loko o kahi kaula. Inā ʻae, hoʻihoʻi ʻo ia i ka TRUE, inā ʻaʻole, FALSE. Inā, ma waho aʻe o ka ʻimi ʻana i nā helu i loko o kahi kelepona, makemake ka mea hoʻohana e hana i nā hana ʻē aʻe, a laila hiki iā ʻoe ke hoʻohana i nā ʻāpana ʻē aʻe o kēia aʻo.

ʻO ka manaʻo ʻelua e pono e wehe ʻia he helu. He huaʻōlelo koʻikoʻi kēia ʻo ia ka nui o nā huaʻōlelo 10 e pili ana i nā helu mai 0 a 9. No laila, i mea e nānā ai i ka hele ʻana o nā helu, pono ka mea hoʻohana e nānā i ka laulā 10 mau manawa. Hiki ke hana i kēia me ka hoʻohana ʻana i ka hana IFakā, he manawa lōʻihi kēia ala.

No ka hoʻoponopono ʻana i kēia pilikia, hiki iā ʻoe ke hoʻohana i kahi ʻano hana kūikawā e hana i nā loiloi āpau i ka hele hoʻokahi: = COUNT(SEARCH({1:2:3:4:5:6:7:8:9:0};A1) )>0 . Loaʻa i kēia hana ka syntax like me ka mea e ʻimi nei i nā huaʻōlelo Cyrillic ma ka kikokikona.

Hiki iā ʻoe ke hoʻohana i kahi add-in i loaʻa i kahi macro i kūkulu ʻia i mea e hana ai i kēia hana. Ma keia hihia, ua lawa wale no ka hoohana ana i ka !SEMTools tab kūikawā, pono e hoohana ia ma kekahi kolamu hou, he kope piha ia o ka mea kumu.

No laila, ʻo ka hoʻonohonoho o nā ʻanuʻu e hana ʻia e kūlike me ka paukū mua. Pono ʻoe e koho mua i ka laulā kumu, kope iā ia, a laila koho i ke kolamu i ʻike ʻia a hoʻopili i kahi macro iā ia e like me ke kaʻina o nā ʻanuʻu i hāʻawi ʻia i kēia animation.

Inā paha pono mākou e ʻimi i kekahi mau helu mai nā mea a pau i hāʻawi ʻia. Pehea e hana ai? ʻO ka mua, e hōʻike mākou iā ʻoe pehea e hana ai me !SEMTools. He maʻalahi ka hoʻohana ʻana i ka mea hana. Ua lawa ka kākau ʻana i nā helu e pono ai ma nā brackets, a laila kaomi i ke pihi OK e hōʻoia. Me ka hoʻohana ʻana i ke ʻano like, hiki iā ʻoe ke loaʻa i ka alphabet Latin a i ʻole e ʻimi i nā leka nui ma kahi laina kikokikona.

Hiki nō hoʻi iā ʻoe ke hoʻohana i ke ʻano e ʻimi ai i nā helu i makemake ʻia i loko o ka laulā o nā cell. No ka hana ʻana i kēia, pono ʻoe e hoʻohana i kahi hui o nā hana E kaha makau i и SEARCH. Me kāna kōkua, ʻaʻole hiki iā ʻoe ke ʻike i nā helu pākahi wale nō, akā i nā kaʻina helu holoʻokoʻa: =СЧЁТ(ПОИСК({01:02:03:911:112};A1))>0.

I kekahi manawa pono ʻoe e ʻimi i nā helu i hoʻokaʻawale ʻia e nā hakahaka. I kēia hihia, kapa ʻia lākou he huaʻōlelo-helu. No ka loaʻa ʻana iā lākou, pono ʻoe e hoʻohana i nā mea hana kūpono ! SEMTools. Hōʻike maopopo kēia animation i nā hana āu e pono ai e hana i mea e hana ai i kēia.

Pehea e ʻike ai inā loaʻa i kahi cell excel nā leka latin

ʻO ka pinepine, huikau nā mea hoʻohana Excel i nā manaʻo o "Find" a me "Extract", ʻoiai aia kahi ʻokoʻa nui ma waena o lākou. ʻO ka ʻōlelo mua, ʻo ia ka nānā ʻana inā aia kekahi ʻano i loko o ke kaula kikokikona a i ʻole ka pae ʻikepili. ʻO ia hoʻi, ʻo ka manaʻo o "Extract" ʻo ia ka huki ʻana i ke ʻano i makemake ʻia mai ka kikokikona a hāʻawi iā ia i kahi hana ʻē aʻe a i ʻole e kākau iā ia i kahi kelepona.

He aha nā mea e pono ai e ʻike i ka huaʻōlelo Latin? No ka laʻana, hiki iā ʻoe ke hoʻohana i nā font kūikawā e hiki ai ke ʻike i nā huaʻōlelo Pelekane ma ka maka. No ka laʻana, hana kēia i ka font Dubai Medium, ka mea e hōʻeuʻeu i nā huaʻōlelo Pelekania.

Akā he aha ka mea e hana ai inā nui ka ʻikepili? I kēia hihia, ʻaʻole lawa ka hoʻoholo ʻana ma ka maka i ke kaʻina o nā waiwai i mea e nānā ai i ka ʻikepili. I kēia hihia, pono ʻoe e ʻimi i nā ala e hoʻokaʻawale i kēia kaʻina hana. Nui nā ala e hiki ai iā ʻoe ke hana i kēia.

Ke hoʻohana nei i kahi hana kūikawā

ʻO ka pilikia nui o ka ʻimi ʻana i nā leka Latin ʻelua a me ka hapa ka nui o lākou ma mua o nā helu. No laila, pono ʻoe e hāʻawi i ka papahana i kahi loop i loaʻa i 26 iterations, hiki ke kaumaha loa. Akā inā e hoʻohana ana i kahi ʻano array e pili ana i nā hana i luna E kaha makau i и SEARCH, a laila, ʻaʻole paʻakikī loa kēia manaʻo: = HELU(HILI({“a”:”b”:”c”:”d”:”e”:”f”:”g”:”h”:”i”:”j”:”k”: »l»:»m»:»n»:»o»:»p»:»q»:»r»:»s»:»t»:»u»:»v»:»w»:x »:»y»:»z»};A1))>0. Hana maikaʻi kēia ʻano kumu no ka hapa nui o nā kūlana. No ka laʻana, inā ʻaʻole hiki ke hoʻokomo i nā macros kūpono e hiki ke hana i kēia maʻalahi a wikiwiki hoʻi.

Ma ke ʻano i hōʻike ʻia ma luna nei, ʻo A1 ka cell kahi i hana ʻia ai ka nānā. No laila, pono ʻoe e kau i ka mea i kūpono i kou kūlana. Hoʻihoʻi kēia hana i kahi waiwai boolean ma muli o ka loiloi. Inā loaʻa kahi pāʻani, a laila hoʻi ka mea hoʻohana oiaioinā ʻaʻole lākou - HEWAE.

Launch SEARCH ʻAʻole ʻae i ka huli ʻana i nā huaʻōlelo. No ka hana ʻana i kēia, pono ʻoe e hoʻohana i ka mea hoʻohana E LOAA, e hana ana i nā hana like, loaʻa nā manaʻo like, ʻo ia wale nō ka hihia-sensitive. ʻO kekahi ala ʻē aʻe, ʻo ia ka hana ʻana i ke ʻano ma luna i kahi ʻano array. Ma keia hihia, e like me keia:{= COUNT(HILI(CHAR(STRING(65:90)),A1))>0}.

No ka mea he ʻano hoʻonohonoho kēia, pono e kuhikuhi ʻia me ka ʻole o nā pale. I kēia hihia, ma hope o ke komo ʻana, pono ʻoe e kaomi i ka hui kī Ctrl + Shift + Enter (ma kahi o ke kaomi wale ʻana i ke kī komo, e like me ke ʻano me ka hana maʻamau), a laila e ʻike ʻia nā braces curly.

Inā pono ʻoe e ʻimi i ka alphabet Cyrillic, ua like ke kaʻina o nā hana, pono wale ʻoe e hoʻonohonoho i ke kaʻina holoʻokoʻa o nā huaʻōlelo Cyrillic e like me ka pae ʻimi. = HELU(HILI({“a”:”b”:”c”:”g”:”e”:”e”:”e”:”g”:”h”:”i”:”d”: ”k”:”l”:”m”:”n”:”o”:”p”:”r”:”s”:”t”:”y”:”f”:”x”:”c »:”h”:”w”:”u”:”b”:”s”:”b”:”e”:”yu”:”i”};A1))>0. Hiki iā ʻoe ke hoʻohana i ka hana SYMBOL, e hana i keia. {=HELU(HILI(CHAR(STRING(192:223)),A1))>0}

Pono e kākau ʻia kēia ʻano hoʻohālike ma ke ʻano he papa kuhikuhi. No laila, pono ʻoe e kaomi i ka hui kī Ctrl + Shift + Enter ma mua o ke kaomi wale ʻana i ke kī komo. Akā aia kekahi mau ʻokoʻa kahi e hana ʻole ai kēia hiʻohiʻona. Pono ʻoe e hōʻoia mua ʻo ka ʻōlelo paʻamau no nā papahana non-Unicode ʻo . I kēia hihia, ʻaʻohe pilikia. He mau ʻokoʻa ko kēia mau ʻōlelo hoʻohālikelike mai kekahi i kekahi. Ma kahi o nā leka 33, hoʻohana ka ʻōlelo hope loa i ka 32. ʻO ia hoʻi, ʻaʻole ia e noʻonoʻo i ka leka ё e like me Cyrillic.

I kēia hihia, e like me ka mea ma mua, no ka ʻimi ʻana i nā huaʻōlelo i makemake ʻia ma ke ʻano hihia, pono ʻoe e hoʻohana i ka hana. E LOAA. No laila, hiki iā ʻoe ke ʻimi, no ka laʻana, ka hapalua o ka pīʻāpā i kākau ʻia ma nā leka liʻiliʻi a me ka hapalua i kākau ʻia i nā leka nui. Ua like nā hoʻopaʻapaʻa.

Pehea e ʻike ai i nā huaʻōlelo i loko o kahi kelepona i loaʻa iā Cyrillic a me Latin

We can logically conclude that to search for those words that contain both Cyrillic and Latin, we need to use as what we are looking for, all the characters of the and English alphabets.

Pehea e ʻike ai i nā leka nui i loko o kahi keena

No ka loaʻa ʻana o nā leka nui, pono ʻoe e hoʻohana i ka hana E LOAA, a no ka hoʻopaʻapaʻa ʻana i nā huaʻōlelo Cyrillic kapikala (a i ʻole nā ​​​​mea o ka alphabet Latin, inā pono ʻoe e ʻimi iā lākou) a i kā lākou code.

When searching for Cyrillic letters through codes, you need to remember that the ASCII table must first be set to . In simple words, to have localization.

Inā pono ʻoe e ʻimi i nā leka nui, me ka nānā ʻole i ka alphabet kahi e pono ai e ʻimi ʻia, pono ʻoe e hoʻohana i nā hana. LOWA и KA MANAʻI… ʻO ke kaʻina o nā hana penei:

1. Hana mākou i nā waiwai liʻiliʻi i loko o kahi cell kaʻawale.
2. Hoʻohālikelike mākou i nā hopena me nā mea mua.
3. Ma hope o kēlā, hoʻohana mākou i kēia ʻano: =ʻAʻole (POLOLE(HAAHA(A1),A1))

Inā like ʻole kēia mau pūnaewele, e hōʻike ana kēia aia kekahi o nā huaʻōlelo i loko o ke kelepona mua ma ka helu kiʻekiʻe.

Ke ʻimi nei i nā huaʻōlelo ma Excel me ka hoʻohana ʻana i nā ʻōlelo maʻamau

Hiki iā ʻoe ke hoʻohana i nā ʻōlelo maʻamau e ʻimi i nā huaʻōlelo. ʻO ke ala maikaʻi loa e hana ai me ka !SEMTools mea hana, ʻoiai ʻo ia ka mea hoʻomaʻamaʻa i ka nui o ke kaʻina o ka hoʻohana ʻana iā lākou. ʻO ke kiko o ka hoʻohana ʻana i nā ʻōlelo maʻamau ma Excel he ākea. E nānā mua mākou i nā hana HULI, PANUI, extract.

ʻO ka nūhou maikaʻi e hiki ke hoʻohana ʻia kēia mau hana ma Google Sheets a me Excel me kēia hoʻonohonoho.

ʻO ka hana maʻamau mua REGEXMATCH, hiki iā ia ke nānā inā like kēia ʻano me ka mea i loko o ke kelepona ʻē aʻe. Syntax: =REGEXMATCH("kikokikona";"RegEx kumu e huli ai"). Hoʻihoʻi kēia hana i kekahi o nā waiwai ʻelua: ʻoiaʻiʻo a i ʻole hewa. He aha ka mea e pili ana i ka nānā ʻana a i ʻole ka pāʻani. ʻO ka hana ʻelua =REGEXEXTRACT("kikokikona";"ʻano hulina RegEx") Hiki iā ʻoe ke unuhi i nā huaʻōlelo i makemake ʻia mai kahi kaula.

Eia nō naʻe, he ʻokoʻa iki kēia hana mai Google Sheets. Aia i loko o ka ʻoiaʻiʻo ʻo ka mea hope, inā ʻaʻole i ʻike ʻia ka kikokikona i ʻōlelo ʻia, e hoʻihoʻi i kahi hewa, ʻoiai ke hōʻike nei kēia add-in i kahi waiwai ʻole.

A ʻo ka mea hope, pono ʻoe e hoʻohana i kēia ʻano hana i mea e pani ai i ka kikokikona: =REGEXREPLACE("kikokikona";"RegEx hulina kumu"; "kikokikona e pani i ka mea i loaʻa").

He aha ka hana me nā hōʻailona i loaʻa

Good. Suppose we have found symbols. What can be done with them next? There are several options here on how to proceed. For example, you can delete them. For example, if we found the Latin alphabet among the Cyrillic values. You can also replace it with a similar character, only in Cyrillic (for example, large English M to M) or extract this character for use in another formula.

Wehe i nā huaʻōlelo hou ma Excel

Nui nā ala e wehe ai i nā huaʻōlelo makemake ʻole ma Excel. ʻO kekahi o nā koho e hoʻohana i ka hana ʻimi a hoʻololi, kahi e hiki ai iā ʻoe ke pani i ke ʻano āu e makemake ai e wehe me kahi kaula ʻole "". Hiki iā ʻoe ke hoʻohana i nā ʻōlelo maʻamau i hoʻohana ʻia e pani i ke ʻano i loaʻa.

Wehe i nā huaʻōlelo kikoʻī ma Excel

Hiki iā ʻoe ke hoʻohana i ka hana "Find" no kēia, akā hiki iā ʻoe ke hoʻohana i ka ʻōlelo maʻamau kūpono, kahi o ka hoʻopaʻapaʻa mua ka kikokikona e unuhi ʻia, a ʻo ka lua ka cell a i ʻole ka laulā e ʻimi ʻia.

Hoʻololi i nā hōʻailona ma Excel

Ua like ke kaʻina hana me ka holoi ʻana, pono e hoʻololi ʻia ke ʻano i makemake ʻia me kahi ʻano ʻē aʻe (me nā mea hiki ʻole ke paʻi ʻia), ʻaʻole i kahi kaula ʻole i ka hoʻopaʻapaʻa pili.