Ua hoʻohana ʻo MacGyver. Ua hoʻohana pū ka hui ʻo Apollo 13. I nā manawa paʻakikī, i ka wā e pono ai ʻoe e hoʻopili i nā mea ʻelua, lawe nā kānaka i ka lipine. Hiki paha iā ʻoe ke kahaha, akā he hana i kūkulu ʻia ʻo Excel e hana like. He hana kēia HOOLAHA (KULA).
Launch HOOLAHA (CONCATENATE) hiki iā ʻoe ke hoʻopili i ʻelua ʻāpana kikokikona a ʻoi aʻe paha i loko o ke kelepona hoʻokahi. ʻOiai ka inoa lōʻihi, he maʻalahi loa ia e hoʻohana a hana like i nā mana āpau o Excel a me nā pāpalapala ʻē aʻe e like me Google Sheets.
'Ōlelo Aʻo: Inā ʻaʻole ʻoe i hoʻohana i nā hana Excel ma mua, hiki iā ʻoe ke kuhikuhi i ka ʻāpana Nā ʻōhumu a me nā hana E ʻike i kā mākou Excel Tutorial no ka poʻe hoʻomaka no ke ʻano o nā kumu aʻo e pili ana i kēia kumuhana.
Hoʻopili inoa
Inā paha he papaʻaina kā mākou me ka ʻike pili i kahi o nā inoa mua a me nā inoa hope i nā kolamu like ʻole. Makemake mākou e loulou iā lākou a loaʻa ka inoa piha no kēlā me kēia kanaka. Ma ke kiʻi ma lalo ʻoe e ʻike ai i nā inoa ma kahi kolamu B, a me nā inoa hope ma ke kolamu A. Aia kā mākou kumu hoʻohālike i loko o kahi keena E2.
Ma mua o ka hoʻomaka ʻana e komo i ke ʻano, e hoʻomaopopo i kahi mea nui: ka hana STsEPIT e hoʻopaʻa wale i ka mea āu i kuhikuhi ai a ʻaʻohe mea ʻē aʻe. Inā makemake ʻoe e hōʻike ʻia nā kaha kaha, nā hakahaka, a i ʻole kekahi mea ʻē aʻe i loko o ke keena, e hoʻohui iā lākou i nā manaʻo hana.
Ma kēia hiʻohiʻona, makemake mākou i kahi ākea ma waena o nā inoa (e pale i kahi mea e like me - JosephineCarter), no laila pono mākou e hoʻohui i kahi ākea i nā hoʻopaʻapaʻa. No laila, e loaʻa iā mākou ʻekolu mau manaʻo:
- B2 (Inoa Mua) – inoa
- "" – ʻano hakahaka ma nā kaha ʻōlelo
- A2 (Inoa Hope) — inoa inoa
I kēia manawa ua wehewehe ʻia nā hoʻopaʻapaʻa, hiki iā mākou ke kākau i ke kelepona E2 eia ke kumu:
=CONCATENATE(B2," ",A2)
=СЦЕПИТЬ(B2;" ";A2)
E like me nā hana Excel ʻē aʻe, he mea nui ka syntax. E hoʻomanaʻo e hoʻomaka me ka hōʻailona like (=) a kau i nā palena (koma a i ʻole semicolon) ma waena o nā manaʻo.
'Ōlelo Aʻo: E kau i kahi koma a i ʻole semicolon ma waena o nā hoʻopaʻapaʻa - pili i ka ʻāina āu e noho ai a me ka mana o Excel āu e hoʻohana ai.
ʻo ia wale nō! Ke paʻi ʻoe komo, e ʻike ʻia ka inoa piha: Josephine Carter.
I kēia manawa, ma ke kauo ʻana i ka lima hoʻopiha piha, e kope i ke ʻano i nā cell āpau a hiki i E11. ʻO ka hopena, e ʻike ʻia ka inoa piha no kēlā me kēia kanaka.
Inā makemake ʻoe e paʻakikī i ka hana, a laila e hoʻohana i ka hana STsEPIT hoʻohui i ke kūlanakauhale a me ka mokuʻāina ma kahi kolamu Fe like me ke kiʻi ma lalo nei:
Hoʻopili i nā helu a me nā kikokikona
Ke hoʻohana nei i nā hana STsEPIT Hiki iā ʻoe ke loulou i nā helu a me nā kikokikona. E noʻonoʻo e hoʻohana mākou iā Excel e mālama i nā moʻolelo waihona no kahi hale kūʻai. I kēia manawa ua loaʻa iā mākou Kōkuhi 25 (apples), akā mālama ʻia ka helu "25" a me ka huaʻōlelo "apples" i loko o nā cell like ʻole. E hoʻāʻo kākou e hoʻopili iā lākou i hoʻokahi cell e loaʻa ai kekahi mea e like me kēia:
Pono mākou e hoʻohui i ʻekolu mau mea:
- F17 (Number in stock) - ka nui
- "" – ʻano hakahaka ma nā kaha ʻōlelo
- F16 (Inoa mea kūʻai
E hoʻokomo i kēia ʻano hoʻohālike i loko o kahi keena E19:
=CONCATENATE(F17," ",F16)
=СЦЕПИТЬ(F17;" ";F16)
E hoʻoikaika kākou! E ʻōlelo mākou makemake mākou e loaʻa: Loaʻa iā mākou he 25 mau hua (He 25 mau ʻāpala kā mākou). No ka hana ʻana i kēia, pono ʻoe e hoʻohui i kahi hoʻopaʻapaʻa hou - ʻo ka huaʻōlelo "Loaʻa iā mākou":
=CONCATENATE("We have ",F17," ",F16)
=СЦЕПИТЬ("We have ";F17;" ";F16)
Hiki iā ʻoe ke hoʻohui i nā hoʻopaʻapaʻa hou aʻe inā makemake ʻoe e hana i kahi ʻōlelo paʻakikī. ʻO ka mea nui e hoʻomanaʻo, ʻo ka syntax o ka formula e pono e pololei loa, inā ʻaʻole hiki ke hana. He mea maʻalahi ke hana hewa i kahi ʻano nui!