Contents
I nehinei i ka marathon 30 mau hana Excel i 30 mau lā ua hāʻule mākou i kahi kaikoʻeke palaualelo nona ka inoa KANAKA (AREAS). ʻAʻole hoʻohana pinepine ʻia kēia hana i ka hoʻomaʻamaʻa, akā me ia ua ʻike mākou i ka hana ʻana o nā mea hoʻohana ʻekolu ma Excel. Manaʻolana ua kōkua kēia kumu aʻo iā ʻoe.
E hāʻawi mākou i ke kolu o ka lā o ka marathon i ke aʻo ʻana i ka hana KANAKA (TRIM). I Ianuali, ke hoʻāʻo nei kekahi e lilo i kekahi mau paona keu, a no kēia kumu hiki iā ʻoe ke hoʻohana iā Excel e hana i ka helu calorie a i ʻole ka pakuhi pohō kaumaha i loko. Minamina ka hana KANAKA ʻAʻole kōkua ʻo TRIM iā ʻoe i ka hakakā ʻana me nā paona ʻē aʻe, akā hiki iā ia ke wehe i nā wahi keu mai ka laina kikokikona.
No laila, e nānā kākou i ka ʻike kuhikuhi a me nā laʻana o ka hoʻohana ʻana i ka hana KANAKA (TRIM) ma Excel. Inā loaʻa iā ʻoe kāu mau hoʻopunipuni a i ʻole nā hiʻohiʻona e pili ana i kēia hana, e ʻoluʻolu e kaʻana iā lākou i nā manaʻo. A pōmaikaʻi me ka helu ʻana i nā calorie!
Hana 03: TRIM
Launch KANAKA (TRIM) hoʻoneʻe i nā hakahaka a pau mai kahi kaula kikokikona koe nā hakahaka hoʻokahi ma waena o nā huaʻōlelo.
Pehea ʻoe e hoʻohana ai i ka hana TRIM?
Launch KANAKA (TRIM) hiki ke kōkua i ka hoʻomaʻemaʻe ʻana i nā kikokikona i hoʻoiho ʻia mai kahi pūnaewele a i lawe ʻia mai kahi noi ʻē aʻe. Hana KANAKA (KUHI):
- Wehe i nā hakahaka ma ka mua a me ka hope o kahi laina.
- Wehe i nā hakahaka a pau mai ka kikokikona koe nā hakahaka hoʻokahi ma waena o nā huaʻōlelo.
- ʻAʻole wehe i kekahi mau huaʻōlelo kūikawā i kope ʻia mai ka pūnaewele.
ʻO TRIM Syntax (TRIM)
Aia ka hana TRIM i kēia syntax:
TRIM(text)
СЖПРОБЕЛЫ(текст)
- text (kikokikona) he kuhikuhi i ke kelepona a i ʻole ke kaula kikokikona āu e makemake ai e wehe i nā hakahaka
MAHI HANA
Launch KANAKA (TRIM) hoʻoneʻe wale i nā huaʻōlelo kikowaena maʻamau mai ka kikokikona. Inā ʻoe e kope ana i ka kikokikona mai kahi pūnaewele puni honua, hiki ke loaʻa i nā huaʻōlelo hakahaka ʻole, e hana ana KANAKA ʻAʻole hiki ke holoi ʻia (TRIM).
Laʻana 1: Wehe i nā hakahaka mai ka hoʻomaka a me ka hopena o kahi kaula kikokikona
Hiki iā ʻoe ke hoʻohana i ka hana KANAKA (TRIM) no ka wehe ʻana i nā wahi alakaʻi a me nā wahi hope mai kahi kaula kikokikona. Ma ke kiʻi ma lalo nei, loaʻa i ka cell C5 ka kikokikona me ʻelua mau hakahaka ma ka hoʻomaka a ʻelua ma ka hope o ka laina. Hana KANAKA (TRIM) i loko o ka cell C7 e wehe i kēlā mau kikowaena 4.
=TRIM(C5)
=СЖПРОБЕЛЫ(C5)
Laʻana 2: Wehe i nā hakahaka āpau ma waena o nā huaʻōlelo
Hiki iā ʻoe ke hoʻohana i ka hana KANAKA (TRIM) i nā hakahaka hou ma waena o nā huaʻōlelo ma ka kikokikona. Ma ke kiʻi ma lalo nei, ʻekolu mau hakahaka hou ma waena o nā huaʻōlelo ma ke kelepona C5. Hana KANAKA (TRIM) i loko o ka cell C7 wehe i kēlā mau hakahaka, me ʻelua mau hakahaka ma ka hoʻomaka a me ka hopena o ke kaula kikokikona.
=TRIM(C5)
=СЖПРОБЕЛЫ(C5)
Laʻana 3: Pehea ʻaʻole e wehe i kekahi mau huaʻōlelo kūikawā
Launch KANAKA (TRIM) ʻAʻole wehe i kekahi mau huaʻōlelo i hoʻohana ʻia ma ke ʻano he hakahaka. No ka laʻana, aia paha kahi hakahaka ʻole i ka kikokikona i kope ʻia mai kahi pūnaewele. Ma ke kiʻi ma lalo nei, loaʻa i ka cell C5 hoʻokahi wahi hakahaka ʻole, ʻaʻole i wehe ʻia.
=TRIM(C5)
=СЖПРОБЕЛЫ(C5)
Hiki iā ʻoe ke hoʻopau i ke ʻano o ka hakahaka me ka lima me ka hoʻohana ʻana i ka hana PALAPALA (SUBSTITUTE) a i ʻole macro. Ma hope aku, i ko mākou marathon 30 mau hana Excel i 30 mau lāE aʻo ʻoe i kekahi mau ala hou e hoʻomaʻemaʻe i ka ʻikepili ma Excel.