Yog tias koj muaj ob daim ntawv tag (lossis tabs) hauv daim ntawv Google Sheets uas koj xav sib piv, muaj cov qauv yooj yim haum uas koj tuaj yeem siv. Qhov wikiHow no yuav qhia koj li cas thiaj pom qhov sib txawv ntawm ob nplooj ntawv hauv Google Ntawv.
Cov kauj ruam
Kauj Ruam 1. Teeb koj ob lub tab hauv Google Cov Ntawv ua ntej
Txoj kev no yuav pab koj sib piv ob lub tab hauv tib daim ntawv Google Ntawv, yog li koj yuav xav tau ob lub tab teeb tsa thiab npaj tau.
Hauv lwm lo lus, yog tias koj muaj ob txoj kev xav zoo sib xws uas koj xav sib piv kom pom qhov sib txawv, muab ib qho rau hauv txhua kab ntawv. Los ntawm lub neej ntawd, cov tab no yuav muaj npe "Sheet1" thiab "Sheet2," tab sis koj tuaj yeem kho lub npe yog tias koj xav tau
Kauj Ruam 2. Tsim daim ntawv thib peb/tab rau koj qhov kev sib piv
Nyem rau "+" kos npe ntawm kaum sab laug sab laug txhawm rau ntxiv daim ntawv no.
Kauj Ruam 3. Nrhiav cell A1 ntawm qhov sib piv tshiab
Sau cov mis
= YOG (Sheet1! A1 Sheet2! A1, Sheet1! A1 & "|" & Sheet2! A1, "")
-
Yog tias koj tau hloov koj cov ntawv yog li lawv tsis hu ua Sheet1 thiab Sheet2, kho cov npe raws li xav tau. Piv txwv, yog tias koj thawj daim ntawv hu ua "Cov Ntaub Ntawv Thawj" thiab daim ntawv thib ob hu ua "Cov Ntaub Ntawv Tshiab," koj cov mis yuav yog
= YOG ('Cov Ntaub Ntawv Thawj'! A1 'Cov Ntaub Ntawv Tshiab'! A1, 'Cov Ntaub Ntawv Tseem Ceeb'! A1 & "|" & 'Cov Ntaub Ntawv Tshiab'! A1, "")
Kauj Ruam 4. Muab cov mis no tso rau txhua lub xov tooj ntawm tes ntawm daim ntawv sib piv
Siv Ctrl+C los theej cov qauv, hais qhia txhua lub cell ntawm daim ntawv sib piv (kom phim cov lej thiab kab uas siv los ntawm koj ob daim ntawv qub), thiab muab tshuaj txhuam siv Ctrl+V.
Kauj Ruam 5. Txheeb xyuas qhov tshwm sim
Daim ntawv sib piv yuav qhia koj qhov twg muaj qhov tsis sib xws muaj nyob nruab nrab ntawm ob nplooj ntawv. Qhov twg qhov txiaj ntsig sib txawv, daim ntawv sib piv yuav qhia ob qho tib si, cais los ntawm cov yeeb nkab cim ("|").
Yog tias koj tsis pom cov ntawv hauv daim ntawv sib piv txhua, nws txhais tau tias ob nplooj ntawv zoo ib yam. Tsuas yog qhov sib txawv yuav tshwm sim
Lub tswv yim
- Koj yuav pom qee qhov sib txawv tau hais tseg yog tias thaj chaw tsis sib xws hauv ib qho ntawm cov haujlwm ntawm daim ntawv teev npe qub. Txhawm rau tshem tawm qhov tsis raug zoo no, xyuas kom koj tsis muaj qhov chaw ntxiv ua ntej lossis tom qab koj cov ntaub ntawv hauv ib daim ntawv uas koj tab tom sib piv.
- Koj yuav pom qee qhov sib txawv tau hais tseg yog tias cov ntawv sib txawv ntawm cov ntawv (piv txwv li, yog tias ib daim ntawv muaj cov ntaub ntawv raug xaiv ua "Plain Text" thiab lwm qhov yog "Tus lej"). Teem txhua daim teb rau tib hom ntawv kom ntseeg tau tias muaj kev sib piv raug.
