Yuav ua li cas ua ke cov ntawv hauv Microsoft Excel (nrog Duab)

2024 Tus sau: Jason Gerald | [email protected]. Kawg hloov kho: 2024-01-19 22:12

Koj puas pom nws nyuaj thaum sim tswj hwm daim ntawv ua haujlwm loj uas muaj cov npe lossis hnub sib cais? Koj puas xav tsim kab lus hauv daim ntawv uas tuaj yeem tuaj yeem suav nrog cov ntaub ntawv los ntawm daim ntawv ua haujlwm? Concatenate muaj nuj nqi ntawm no yog kom txuag koj lub sijhawm! Ua raws li phau ntawv qhia no kom sai ua ke qhov tseem ceeb los ntawm ntau lub cell hauv koj daim ntawv Excel.

Kauj ruam

Kauj Ruam 1. Siv Concatenate los ua ke ob lub cell

Lub luag haujlwm tseem ceeb ntawm kev sib txuas yog txhawm rau txuas ob lossis ntau kab ntawv ua ke. Koj tuaj yeem sib txuas 255 txoj hlua sib txawv ua ke siv ib qho lus txib sib txuas. Xav txog qhov piv txwv hauv qab no:

Nkag mus rau Formula

	A	B	C
1	zoo	nyob zoo	= Sib txheeb (A1, B1)

Qhov tshwm sim

	A	B	C
1	zoo	nyob zoo	nyob zoo

Kauj Ruam 2. Nkag mus rau qhov chaw nruab nrab ntawm cov ntawv koj tab tom koom ua ke

Yog tias koj xav sib txuas cov ntawv tab sis xav tau qhov chaw nruab nrab ntawm lawv, koj tuaj yeem ntxiv qhov chaw rau cov qauv nrog cov lus hais nyob ib puag ncig ib qho chaw. Qhov no muaj txiaj ntsig tshwj xeeb rau cov ntaub ntawv xws li lub npe thiab lub xeem. Piv txwv li:

Nkag mus rau Formula

	A	B	C
1	John	Smith	= Sib koom (A1, "", B1)

Qhov tshwm sim

	A	B	C
1	John	Smith	John Smith

Kauj Ruam 3. Ntxig cov cim cim thiab lwm cov ntawv ntawm cov hlua sib txuas

Raws li pom saum toj no, koj tuaj yeem ntxiv qhov chaw los ntawm kev tso cov lus hais nyob ib puag ncig ntawm qhov chaw khoob hauv cov mis. Koj tuaj yeem nthuav nws thiab siv cov lus hais los ntxig cov ntawv rau hauv koj qhov kev koom tes. Ua tib zoo saib xyuas qhov chaw hauv cov lus hais los ua kab lus uas tuaj yeem 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. Ua ke hnub sib txawv

Yog tias koj muaj ntau cov hnub uas koj xav ua ke, koj yuav tsum 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 "&" hloov qhov Concatenate

"&" ua haujlwm zoo ib yam li Concatenate. Qhov no tuaj yeem muaj txiaj ntsig rau cov qauv luv, tab sis tuaj yeem cuam tshuam sai sai rau cov qauv ntev. Pom cov chaw nyob hauv nqe lus. Koj yuav tsum sau "&" nruab nrab ntawm txhua tus nqi uas koj xav ua ke.

Nkag mus rau Formula

	A	B	C
1	John	Smith	= A1 & "" & B1

Qhov tshwm sim

	A	B	C
1	John	Smith	John Smith