Yuav Tshem Tawm Ntxiv Cov Txij Ntawm Cov Ntaub Ntawv Hauv Google Tshaj Tawm

01 ntawm 02

Google Spreadsheets'TRIM Function

Thaum cov ntaub ntawv luam tawm lossis xa mus rau hauv Google Spreadsheet tej qhov chaw muaj qee zaum nrog rau cov ntaub ntawv luam tawm.

Rau hauv computer, qhov chaw ntawm cov lus tsis yog qhov chaw tsis muaj dab tsi tab sis ib cim, thiab, cov cim ntxiv no yuav cuam tshuam rau cov ntaub ntawv siv nyob rau hauv ib daim ntawv ua haujlwm - xws li hauv txoj kev sib koom ua ke uas muab ntau lub hlwb cov ntaub ntawv rau hauv ib qho.

Ntau dua li manually editing cov ntaub ntawv los tshem tawm cov chaw tsis txaus siab, siv TRIM kev ua haujlwm kom tshem tej qhov chaw ntxiv ntawm cov lus los yog lwm cov ntawv nyeem cov hlua .

Qhov Kev Luam Tshaj ntawm TRIM's Syntax thiab Kev Sib Tham

Ib qho kev ua haujlwm syntax hais txog qhov teeb tsa ntawm txoj haujlwm thiab suav nrog txoj haujlwm, lub npe, thiab sib cam .

Tus syntax rau TRIM ua haujlwm yog:

= TRIM (ntawv nyeem)

Qhov kev sib cav rau TRIM muaj nuj nqi yog:

ntawv - cov ntaub ntawv koj xav tshem tawm ntawm cov chaw. Qhov no yuav ua tau:

• qhov tseeb cov ntaub ntawv yuav tsum tau trimmed
• tus xov tooj ntawm tes mus rau qhov chaw nyob ntawm cov ntawv sau hauv cov ntawv ua haujlwm

Lus Cim: Yog qhov tseeb cov ntaub ntawv luas yuav raug siv raws li cov lus sib cav, nws yuav tsum muab xa nrog cov lus hais tias, xws li:

= TRIM ("Tshem tawm qhov chaw nrawm")

Tshem cov Ntaub Ntawv Tseem Ceeb nrog Muab Tshuaj Rau Tshwj Xeeb

Yog hais tias lub xov tooj xa mus rau qhov chaw ntawm cov ntaub ntawv yuav tsum tau siv los ua cov lus sib cav, qhov kev ua haujlwm tsis tuaj yeem nyob hauv tib lub xov tooj ntawm cov ntaub ntawv qub.

Raws li qhov tshwm sim, cov ntaub ntawv keeb kwm feem cuam tshuam yuav tsum nyob twj ywm hauv nws qhov chaw qub hauv daim ntawv ua haujlwm. Qhov no tuaj yeem muaj teeb meem yog tias muaj ntau ntau cov ntaub ntawv luas lossis yog cov ntaub ntawv tseem ceeb nyob hauv ib qho chaw ua haujlwm tseem ceeb.

Ib txoj kev nyob ib ncig ntawm qhov teeb meem no yog siv Paste Special rau tsuas yog muab cov ntsiab lus tseem ceeb tom qab cov ntaub ntawv tau muab luam tawm. Qhov no txhais tau tias qhov TRIM kev ua haujlwm tau muab rov qab rau sab saum toj ntawm cov ntaub ntawv qub thiab ces TRIM kev ua haujlwm raug tshem tawm.

Piv txwv: Tshem Cov Ntxiv Ntxiv nrog Kev Ua Haujlwm TRIM

Piv txwv li no muaj cov kauj ruam tsim nyog rau:

• tshem tej qhov chaw ntxiv ntawm qhov peb kab ntawm cov ntawv nyeem hauv kab 1 txog 3 hauv daim ntawv ua haujlwm - raws li muaj nyob hauv daim duab saum toj no;
• cov ntaub ntawv trimmed yuav muab luam tawm thiab tom qab muab tshuaj txhuam tshwj xeeb siv los hloov cov ntaub ntawv tseem ceeb hauv thawj peb kab;
• qhov TRIM functions siv los tshem tawm cov nruam ntxiv yuav ces muab tshem tawm.

Nkag mus rau hauv Cov Ntaub Ntawv Xov Xwm

1. Qhib Google Spreadsheet uas muaj cov ntsiab lus ntxiv uas yuav tsum tau muab tshem tawm, lossis luam tawm thiab muab cov kab hauv qab rau hauv hlwb A1 A3 rau hauv daim ntawv ua haujlwm Tshaj 1 ntawm Cov Ntaub Ntawv Muaj Cov Chaw Ntxiv Tshaj 2 ntawm Cov Ntaub Ntawv nrog Cov Chaw Ntxiv Kab 3 Ntxiv Chaw

02 ntawm 02

Nkag mus hauv TRIM Function

Nkag mus hauv TRIM Function

Google Spreadsheets tsis siv cov thawv rau kev sib txuas lus los nkag rau cov lus sib cav raws li muaj nyob rau hauv Excel. Xwb, nws muaj lub thawv pib-hais tias pops tuaj li lub npe ntawm qhov ua haujlwm yog ntaus rau hauv ib lub xov tooj ntawm tes.

1. Yog tias koj siv koj cov ntaub ntawv, nias rau hauv daim ntawv khij ntawm tes uas koj xav tau cov ntaub ntawv trimmed mus nyob
2. yog tias koj ua raws li qhov ua piv txwv no, nias rau ntawm A6 los ua nws lub xovtooj ntawm tes - qhov no yog qhov twg qhov TRIM kev ua haujlwm yuav raug nkag mus thiab nyob rau qhov twg cov ntawv luam tawm yuav tsum tau sau
3. Ntaus qhov cim sib npaug (=) tom qab lub npe ntawm qhov kev ua haujlwm
4. Raws li koj ntaus, nws pib-qhia lub thawv tshwm nrog lub npe ntawm cov haujlwm uas pib nrog tsab ntawv T
5. Thaum lub npe TRIM tshwm nyob rau hauv lub thawv, nyem rau ntawm lub npe nrog tus pointer pointer mus rau hauv lub npe muaj nuj nqi thiab qhib kab bracket rau hauv cell A6

Nkag Mus Hauv Qhov Kev Lag Luam Qhov Sib Cav

Raws li pom hauv daim duab saum toj no, qhov kev sib cav rau TRIM kev ua haujlwm yog nkag tom qab qhib kab bracket.

1. Nias ntawm Cell A1 hauv daim ntawv ua haujlwm los nkag rau lub xov tooj ntawm tes siv ua cov lus sib cav
2. Nias tus Sau rau ntawm tus keyboard kom nkag mus rau ib qho kev kaw lus "" ) "tom qab qhov kev ua haujlwm qhov sib cav thiab kom tiav txoj haujlwm
3. Cov kab ntawm cov ntawv nyeem ntawm Cell A1 yuav tsum tshwm nyob hauv cell A6, tab sis tsuas yog muaj ib qhov chaw nruab nrab ntawm txhua lo lus
4. Thaum koj nias rau ntawm A6 cell qhov ua tiav tiav = TRIM (A1) tshwm nyob rau ntawm qhov formula mis saum toj ntawm daim ntawv ua haujlwm.

Luam cov kev ua nrog rau kev ua haujlwm

Tus tuav daim ntawv yog siv los luam qhov TRIM kev ua haujlwm hauv Cell A6 rau hlwb A7 thiab A8 kom tshem tawm cov nrug ntxiv ntawm cov kab ntawv ntawm cov ntawv nyeem A2 thiab A3.

1. Nias ntawm A6 cell kom nws ua haujlwm ntawm tes
2. Muab tus pointer poias dua rau hauv lub xwmfab dub nyob rau hauv qab yog kaum ntawm tes A6 - tus pointer yuav hloov mus rau ib qho ntxiv rau " + "
3. Nyem thiab tuav lub khawm laug nas thiab luag tus ua daim pib mus rau ntawm A8 ntawm tes
4. Tso lub khawm nas - Lub hlwb A7 thiab A8 yuav tsum muaj cov kab ntawm cov ntawv nyeem A3 thiab A3 raws li tau hais nyob hauv daim duab ntawm nplooj 1

Tshem cov Ntaub Ntawv Tseem Ceeb nrog Muab Tshuaj Rau Tshwj Xeeb

Thawj cov ntaub ntawv hauv hlwb A1 rau A3 yuav raug tshem tawm tsis cuam tshuam cov ntaub ntawv trimmed by using paste tshwj xeeb tus muab tshuaj txhuam qhov tseem ceeb xaiv los paste dhau cov thawj cov ntaub ntawv hauv hlwb A1 rau A3.

Tom qab ntawd, qhov TRIM ua haujlwm hauv hlwb A6 rau A8 tseem yuav raug tshem tawm txij li lawv tsis tas yuav ntxiv.

#REF! uas tsis yog : Yog tias ib daim ntawv tsis tu ncua thiab muab tshuaj khi cia siv ntau dua li qhov tseem ceeb , qhov TRIM zog yuav muab pov rau hauv hlwb A1 rau A3, uas yuav ua rau ntau tus #REF! Cov teeb meem raug tshwm nyob rau hauv daim ntawv khij nyiab.

1. Highlight hlwb A6 rau A8 hauv tsab ntawv khom nqi
2. Luam cov ntaub ntawv hauv cov hlwb siv Ctrl + C ntawm cov keyboard lossis hloov> Daim ntawv los ntawm menus - peb lub hlwb yuav tsum tau sau tseg nrog lub dashed lined ciam rau qhia tias lawv tseem tau theej
3. Nyem ntawm tes A1
4. Nias ntawm Kho kom raug> Muab tshuaj txhuam tshwjxeeb> Nqa cov kabmob hauv qhov tseem ceeb hauv cov ntawv teev khoom xwb los ua rau TRIM kev ua haujlwm hauv hlwb A1 rau A3
5. Cov ntawv nyeem trimmed yuav tsum muaj nyob hauv hlwb A1 rau A3 thiab cov hlwb A6 rau A8
6. Highlight hlwb A6 rau A8 hauv tsab ntawv khom nqi
7. Nias qhov rho tawm qhov tseem ceeb ntawm cov keyboard kom rho tawm qhov peb TRIM ua haujlwm
8. Cov ntaub ntawv trimmed tseem yuav tsum tuaj nyob rau hauv hlwb A1 rau A3 tom qab Hmong lub functions