Yuav Ua Li Cas Tshem Qhov Chaw Ntawm Cov Cim thiab Tus Zauv hauv Excel

Cov txheej txheem:

Yuav Ua Li Cas Tshem Qhov Chaw Ntawm Cov Cim thiab Tus Zauv hauv Excel
Yuav Ua Li Cas Tshem Qhov Chaw Ntawm Cov Cim thiab Tus Zauv hauv Excel

Video: Yuav Ua Li Cas Tshem Qhov Chaw Ntawm Cov Cim thiab Tus Zauv hauv Excel

Video: Yuav Ua Li Cas Tshem Qhov Chaw Ntawm Cov Cim thiab Tus Zauv hauv Excel
Video: Musicians talk about Buckethead 2024, Plaub Hlis Ntuj
Anonim

Qhov wikiHow no qhia koj li cas kom tshem tawm cov chaw tsis xav tau los ntawm cov cell hauv daim ntawv Excel.

Cov kauj ruam

Txoj Kev 1 ntawm 2: Siv Nrhiav thiab Hloov

Tshem Qhov Chaw Ntawm Cov Cim thiab Tus Zauv hauv Excel Kauj Ruam 1
Tshem Qhov Chaw Ntawm Cov Cim thiab Tus Zauv hauv Excel Kauj Ruam 1

Kauj Ruam 1. Qhia txog qhov ntau uas koj xav tshem tawm txhua qhov chaw

Piv txwv li, yog tias koj xav tshem qhov chaw los ntawm C2 txog C30, hais txog cov hlwb ntawd.

Tshem Qhov Chaw Ntawm Cov Cim thiab Tus Zauv hauv Excel Kauj Ruam 2
Tshem Qhov Chaw Ntawm Cov Cim thiab Tus Zauv hauv Excel Kauj Ruam 2

Kauj ruam 2. Nyem rau Kho kom raug cov zaub mov

Tshem Qhov Chaw Ntawm Cov Cim thiab Tus Zauv hauv Excel Kauj Ruam 3
Tshem Qhov Chaw Ntawm Cov Cim thiab Tus Zauv hauv Excel Kauj Ruam 3

Kauj Ruam 3. Xaiv Nrhiav

Tshem Qhov Chaw Ntawm Cov Cim thiab Tus Zauv hauv Excel Kauj Ruam 4
Tshem Qhov Chaw Ntawm Cov Cim thiab Tus Zauv hauv Excel Kauj Ruam 4

Kauj Ruam 4. Xaiv Hloov…

Lub thawv sib tham yuav tshwm sim.

Tshem Qhov Chaw Ntawm Cov Cim thiab Tus Zauv hauv Excel Kauj Ruam 5
Tshem Qhov Chaw Ntawm Cov Cim thiab Tus Zauv hauv Excel Kauj Ruam 5

Kauj Ruam 5. Nyem rau lub npov hauv qab “Nrhiav Dab Tsi

Tshem Qhov Chaw Ntawm Cov Cim thiab Tus Zauv hauv Excel Kauj Ruam 6
Tshem Qhov Chaw Ntawm Cov Cim thiab Tus Zauv hauv Excel Kauj Ruam 6

Kauj Ruam 6. Nias qhov chaw seem ntawm cov keyboard

Nco ntsoov nias nws ib zaug xwb.

Tshem Qhov Chaw Ntawm Cov Cim thiab Tus Zauv hauv Excel Kauj Ruam 7
Tshem Qhov Chaw Ntawm Cov Cim thiab Tus Zauv hauv Excel Kauj Ruam 7

Kauj Ruam 7. Nyem Hloov Tag Nrho

Nws yog lub pob thib ob nyob hauv qab ntawm lub qhov rais. Tam sim no cov chaw tau raug tshem tawm los ntawm cov cell xaiv. Ib qho pop-up yuav tshwm, qhia rau koj paub tias muaj pes tsawg qhov chaw raug tshem tawm.

Tshem Qhov Chaw Ntawm Cov Cim thiab Tus Zauv hauv Excel Kauj Ruam 8
Tshem Qhov Chaw Ntawm Cov Cim thiab Tus Zauv hauv Excel Kauj Ruam 8

Kauj ruam 8. Nyem OK

Txoj Kev 2 ntawm 2: Siv Txoj Haujlwm Hloov

Tshem Qhov Chaw Ntawm Cov Cim thiab Tus Zauv hauv Excel Kauj Ruam 9
Tshem Qhov Chaw Ntawm Cov Cim thiab Tus Zauv hauv Excel Kauj Ruam 9

Kauj Ruam 1. Nyem rau sab saum toj ntawm kab lus hauv kab dawb paug

Lub xovtooj ntawm tes yuav tsum nyob rau kab tib yam li thawj kab ntawm cov ntaub ntawv hauv kem nrog qhov chaw.

Piv txwv li, yog tias koj xav tshem qhov chaw los ntawm kab C, thiab C thawj kab ntawm cov ntaub ntawv nyob hauv kab 2 (C2), nyem lub xov tooj thib ob hauv koj kab ntawv khoob (piv txwv li E2, F2, G2, thiab lwm yam)

Tshem Qhov Chaw Ntawm Cov Cim thiab Tus Zauv hauv Excel Kauj Ruam 10
Tshem Qhov Chaw Ntawm Cov Cim thiab Tus Zauv hauv Excel Kauj Ruam 10

Kauj Ruam 2. Hom = Hloov Chaw

Tshem Qhov Chaw Ntawm Cov Cim thiab Tus Zauv hauv Excel Kauj Ruam 11
Tshem Qhov Chaw Ntawm Cov Cim thiab Tus Zauv hauv Excel Kauj Ruam 11

Kauj Ruam 3. Nyem rau thawj lub xovtooj ntawm kab uas muaj kab

Piv txwv li, yog tias koj xav tshem txhua qhov chaw ntawm kab C, nyem rau thawj lub npov (piv txwv li C2) hauv kab ntawv uas tsis yog lub npe.

Yog tias koj nyem cell C2, cov qauv yuav tsum tam sim no zoo li no: = Hloov chaw (C2

Tshem Qhov Chaw Ntawm Cov Cim thiab Tus Zauv hauv Excel Kauj Ruam 12
Tshem Qhov Chaw Ntawm Cov Cim thiab Tus Zauv hauv Excel Kauj Ruam 12

Kauj Ruam 4. Ntaus, (tus lej cim)

Tam sim no lub xov tooj yuav tsum zoo li no: = Hloov chaw (C2,.

Tshem Qhov Chaw Ntawm Cov Cim thiab Tus Zauv hauv Excel Kauj Ruam 13
Tshem Qhov Chaw Ntawm Cov Cim thiab Tus Zauv hauv Excel Kauj Ruam 13

Kauj Ruam 5. Ntaus "",

Muaj qhov chaw nruab nrab ntawm ob pawg ntawm cov lus hais-qhov no tseem ceeb.

Cov mis yuav tsum zoo li no: = Hloov chaw (C2, "",

Tshem Qhov Chaw Ntawm Cov Cim thiab Tus Zauv hauv Excel Kauj Ruam 14
Tshem Qhov Chaw Ntawm Cov Cim thiab Tus Zauv hauv Excel Kauj Ruam 14

Kauj Ruam 6. Ntaus "")

Lub sijhawm no, Tsis muaj qhov chaw nruab nrab ntawm cov lus hais.

Cov mis yuav tsum zoo li no: = Hloov chaw (C2, "", "")

Tshem Qhov Chaw Ntawm Cov Cim thiab Tus Zauv hauv Excel Kauj Ruam 15
Tshem Qhov Chaw Ntawm Cov Cim thiab Tus Zauv hauv Excel Kauj Ruam 15

Kauj Ruam 7. Nias ↵ Enter los yog ⏎ Rov qab los.

Tam sim no koj yuav pom cov ntsiab lus ntawm cov xov tooj uas tau xaiv (C2, hauv qhov piv txwv no) tsis muaj chaw nyob hauv kab ntawv tshiab.

Piv txwv li, yog C2 hais tias www. wikih ow.com, koj lub cell tshiab yuav hais www.wikihow.com

Tshem Qhov Chaw Ntawm Cov Cim thiab Tus Zauv hauv Excel Kauj Ruam 16
Tshem Qhov Chaw Ntawm Cov Cim thiab Tus Zauv hauv Excel Kauj Ruam 16

Kauj Ruam 8. Nyem lub xovtooj ntawm tes nrog cov qauv koj tau ntaus

Tam sim no lub xov tooj yuav tsum tau hais txog.

Tshem Qhov Chaw Ntawm Cov Cim thiab Tus Zauv hauv Excel Kauj Ruam 17
Tshem Qhov Chaw Ntawm Cov Cim thiab Tus Zauv hauv Excel Kauj Ruam 17

Kauj Ruam 9. Luag cov ntawv sau cia hla cov cell uas koj xav sau

Cov ntaub ntawv los ntawm txhua lub xovtooj sib txuas tam sim no yuav tshwm nyob rau hauv koj kab ntawv tshiab yam tsis muaj chaw nyob.

Tshem Qhov Chaw Ntawm Cov Cim thiab Tus Zauv hauv Excel Kauj Ruam 18
Tshem Qhov Chaw Ntawm Cov Cim thiab Tus Zauv hauv Excel Kauj Ruam 18

Kauj Ruam 10. Luam cov ntaub ntawv los ntawm kab ntawv tshiab mus rau kab thawj

Koj cov ntaub ntawv tsis muaj chaw tshiab yog tam sim no.

Pom zoo: