MacGyver siv nws. Cov neeg coob Apollo 13 kuj tau siv nws. Ib txwm nyob rau hauv ib qho teeb meem nyuaj, thaum koj xav tau txuas ob yam, tib neeg khaws daim kab xev. Tej zaum koj yuav xav tsis thoob, tab sis Excel muaj cov haujlwm ua haujlwm uas ua tau zoo ib yam. Qhov no yog ib txoj haujlwm CONCATENATE (CLUTCH).
muaj nuj nqi CONCATENATE (CONCATENATE) tso cai rau koj txuas ob lossis ntau daim ntawv ntawm cov ntawv hauv ib lub xov tooj. Txawm hais tias lub npe ntev, nws yooj yim heev rau siv thiab ua haujlwm zoo ib yam hauv txhua qhov ntawm Excel nrog rau lwm cov ntawv nthuav qhia xws li Google Sheets.
Nco ntsoov: Yog tias koj tsis tau siv Excel ua haujlwm ua ntej, koj tuaj yeem xa mus rau ntu Formulas thiab Functions Saib peb Excel Tutorial rau Beginners rau ib tug series ntawm tutorials ntawm lub ncauj lus no.
Txuas cov npe
Piv txwv tias peb muaj ib lub rooj nrog cov ntaub ntawv tiv tauj uas thawj thiab lub xeem nyob rau hauv kab sib txawv. Peb xav txuas lawv thiab tau txais lub npe tag nrho rau txhua tus neeg. Hauv daim duab hauv qab no koj pom cov npe hauv kab B, thiab cov npe xeem hauv kab A. Peb cov qauv yuav nyob hauv ib lub cell E2.
Ua ntej peb pib nkag mus rau hauv cov qauv, nkag siab txog qhov tseem ceeb: kev ua haujlwm STEPIT yuav tsuas khi yam koj qhia thiab tsis muaj dab tsi ntxiv. Yog tias koj xav kom cov cim cim, qhov chaw, lossis lwm yam tshwm sim hauv lub xov tooj, ntxiv rau lawv rau cov lus sib cav.
Hauv qhov piv txwv no, peb xav tau qhov chaw nruab nrab ntawm cov npe (kom zam qee yam xws li - JosephineCarter), yog li peb yuav tau ntxiv qhov chaw rau cov lus sib cav. Yog li, peb yuav muaj peb qhov kev sib cav:
- B2 (Lub Npe) - lub npe
- "" - qhov chaw cim hauv cov lus hais
- A2 (Lub xeem) - lub xeem
Tam sim no hais tias cov lus sib cav tau txiav txim siab, peb tuaj yeem sau rau hauv lub xov tooj ntawm tes E2 ntawm no yog tus qauv:
=CONCATENATE(B2," ",A2)
=СЦЕПИТЬ(B2;" ";A2)
Raws li nrog rau lwm yam Excel muaj nuj nqi, syntax tseem ceeb. Nco ntsoov pib nrog lub cim sib npaug (=) thiab muab tus lej cim (comma lossis semicolon) ntawm cov lus sib cav.
Nco ntsoov: muab ib qho comma los yog ib lub cim ntawm cov lus sib cav - nyob ntawm seb lub teb chaws twg koj nyob thiab dab tsi ntawm Excel koj siv.
Yog tag nrho! Thaum koj nias Sau, lub npe tag nrho yuav tshwm sim: Josephine Carter.
Tam sim no, los ntawm kev rub tus autofill kov, luam cov qauv rau txhua lub hlwb mus txog E11. Yog li ntawd, lub npe tag nrho yuav tshwm sim rau txhua tus neeg.
Yog tias koj xav ua kom nyuaj rau txoj haujlwm, ces sim siv cov haujlwm STEPIT txuas lub nroog thiab xeev hauv ib kab Fkom zoo li daim duab hauv qab no:
Koom nrog cov lej thiab ntawv
Siv cov haujlwm STEPIT Koj tuaj yeem txuas tus lej thiab cov ntawv nyeem. Cia peb xav txog tias peb siv Excel los khaws cov ntaub ntawv khaws tseg rau lub khw. Tam sim no peb muaj 25 txiv apples (apples), tab sis tus naj npawb "25" thiab lo lus "apples" yog khaws cia rau hauv cov hlwb sib txawv. Cia peb sim txuas lawv hauv ib lub xov tooj kom tau txais qee yam zoo li no:
Peb yuav tsum txuas peb yam:
- F17 (Ntau hauv Tshuag) - kom muaj nuj nqis
- "" - qhov chaw cim hauv cov lus hais
- F16 (Product) - npe
Nkag mus rau cov qauv hauv qab no hauv ib lub cell E19:
=CONCATENATE(F17," ",F16)
=СЦЕПИТЬ(F17;" ";F16)
Wb ua kom nyuaj! Cia peb hais tias peb xav tau: Peb muaj 25 txiv apples (Peb muaj 25 txiv apples). Txhawm rau ua qhov no, koj yuav tsum ntxiv ib qho kev sib cav ntxiv - kab lus "Peb muaj":
=CONCATENATE("We have ",F17," ",F16)
=СЦЕПИТЬ("We have ";F17;" ";F16)
Koj tuaj yeem ntxiv cov lus sib cav ntau dua yog tias koj xav tsim cov lus qhia ntau dua. Lub ntsiab tseem ceeb uas yuav tsum nco ntsoov yog tias cov syntax ntawm cov mis yuav tsum yog qhov tseeb, txwv tsis pub nws yuav tsis ua haujlwm. Nws yog ib qho yooj yim ua yuam kev hauv cov mis loj!