Puas yog koj rub koj cov plaub hau los sim tswj hwm daim ntawv nthuav dav uas muaj cov npe lossis hnub tsis sib xws? Koj puas xav tsim cov kab lus uas tuaj yeem ua tiav nrog cov ntaub ntawv los ntawm koj daim ntawv teev npe? Concatenate muaj nuj nqi nyob ntawm no kom txuag hnub! Ua raws li phau ntawv qhia no kom koom nrog qhov tseem ceeb ntawm ntau lub cell hauv koj daim ntawv Excel.
Cov kauj ruam
Kauj Ruam 1. Siv Concatenate koom nrog ob lub cell
Lub luag haujlwm tseem ceeb ntawm kev sib koom tes yog koom nrog ob lossis ntau kab ntawv ua ke. Koj tuaj yeem koom nrog txog 255 txoj hlua sib txawv ua ke siv ib lo lus sib hais ua ke. Ua piv txwv li no:
Raws li pom saum toj no, koj tuaj yeem ntxiv qhov chaw los ntawm kev sau cov lus hais ib ncig ntawm qhov chaw khoob hauv cov mis. Koj tuaj yeem nthuav qhov no thiab siv cov cim hais los txhawm rau ntxig cov ntawv rau hauv koj qhov kev sib koom. Nco tseg ntawm qhov sib nrug sab laug hauv kab lus hais kom ua kab lus nyeem tau.
Nkag mus rau Formula
A
B
C
1
Hnub Monday
Friday
= Sib koom ua ke (A1, " -", B1, ", kaw hnub so.")
Qhov tshwm sim
A
B
C
1
Hnub Monday
Friday
Hnub Monday - Friday, kaw hnub so.
Kauj Ruam 4. Sib sau ntau yam hnub tim
Yog tias koj muaj hnub tim uas koj xav koom nrog, koj yuav tsum tau siv TEXT ua haujlwm los tiv thaiv Excel los ntawm kev kho cov hnub raws li lej lej:
Nkag mus rau Formula
A
B
C
1
2013-14-01
2013-17-06
= Sib koom ua ke (Ntawv (A1, "MM/DD/YYYY"), " -", Ntawv (B1, "MM/DD/YYYY"))
Qhov tshwm sim
A
B
C
1
2013-14-01
2013-17-06
2013-14-01 - 2013-17-06
Kauj Ruam 5. Siv lub cim "&" los hloov ua Concatenate
Yog li koj puas tau xav siv koj Lub Xov Tooj Hluav Taws Xob USB txuas lossis Laptop daim npav txuas rau lub router kom muaj wireless hauv tsev, tab sis tsis muaj qhov qhia tias yuav ua li cas? kev sib txuas Koj tau pom cov no $ 150- $ 200 routers tawm los uas koj tuaj yeem tso koj daim npav USB lossis Laptop Broadband rau hauv thiab siv koj li kev txuas xov tooj ntawm tes txuas rau wireless router.