txheem
Nag hmo hauv marathon 30 Excel ua haujlwm hauv 30 hnub peb ntog rau ntawm ib tug tub qhev npe hu ua NPAJ (AREAS). Qhov kev ua haujlwm no tsis yog siv ntau zaus hauv kev xyaum, tab sis nrog nws peb pom li cas peb tus neeg ua haujlwm siv ua haujlwm hauv Excel. Vam tias qhov kev qhia no yuav pab tau koj.
Peb yuav mob siab rau hnub thib peb ntawm marathon rau txoj kev kawm ntawm txoj haujlwm TRIM (TRIM). Thaum Lub Ib Hlis, ib tus neeg tab tom sim poob ob peb phaus ntxiv, thiab rau lub hom phiaj no koj tuaj yeem siv Excel los tsim cov calorie txee lossis cov duab poob hauv nws. Hmoov tsis muaj nuj nqi TRIM (TRIM) yuav tsis pab koj tawm tsam cov phaus ntxiv, tab sis nws tuaj yeem tshem tawm qhov chaw ntxiv ntawm kab ntawv.
Yog li cia peb saib cov ntaub ntawv siv thiab piv txwv ntawm kev siv lub luag haujlwm TRIM (TRIM) hauv Excel. Yog tias koj muaj koj tus kheej tricks lossis piv txwv ntawm txoj haujlwm no, thov qhia rau lawv hauv cov lus. Thiab hmoov zoo nrog suav calories!
Function 03: TRIM
muaj nuj nqi TRIM (TRIM) tshem tawm txhua qhov chaw ntawm kab ntawv tsuas yog ib qho chaw ntawm cov lus.
Koj tuaj yeem siv TRIM ua haujlwm li cas?
muaj nuj nqi TRIM (TRIM) tuaj yeem pab ntxuav cov ntawv rub tawm los ntawm lub vev xaib lossis xa tawm los ntawm lwm daim ntawv thov. Muaj nuj nqi TRIM (TRIM):
- Tshem tawm qhov chaw thaum pib thiab xaus ntawm kab.
- Tshem tawm txhua qhov chaw ntawm cov ntawv nyeem tsuas yog ib qho chaw ntawm cov lus.
- TSIS tshem qee cov cim tshwj xeeb uas tau theej los ntawm lub vev xaib.
TRIM Syntax (TRIM)
TRIM muaj nuj nqi muaj cov hauv qab no syntax:
TRIM(text)
СЖПРОБЕЛЫ(текст)
- text (cov ntawv nyeem) yog ib qho kev siv rau lub xov tooj ntawm tes lossis cov kab ntawv uas koj xav tshem tawm qhov chaw
TRIM TRAP
muaj nuj nqi TRIM (TRIM) tsuas yog tshem tawm cov cim qhov chaw ntawm cov ntawv nyeem. Yog tias koj luam cov ntawv los ntawm lub vev xaib, nws yuav muaj cov cim tsis sib xws, uas ua haujlwm TRIM (TRIM) tsis tuaj yeem muab tshem tawm.
Piv txwv 1: Tshem tawm qhov chaw ntawm qhov pib thiab qhov kawg ntawm kab ntawv
Koj tuaj yeem siv txoj haujlwm TRIM (TRIM) tshem tawm txhua qhov chaw ua ntej thiab tom qab ntawm kab ntawv. Hauv daim duab hauv qab no, xov tooj ntawm tes C5 muaj cov ntawv nyeem nrog ob qhov chaw ntxiv thaum pib thiab ob qhov kawg ntawm kab. Muaj nuj nqi TRIM (TRIM) hauv cell C7 tshem tawm 4 qhov chaw ntxiv.
=TRIM(C5)
=СЖПРОБЕЛЫ(C5)
Piv txwv 2: Tshem tag nrho tab sis ib qho chaw ntawm cov lus
Koj tuaj yeem siv txoj haujlwm TRIM (TRIM) rau qhov chaw ntxiv ntawm cov lus hauv cov ntawv nyeem. Hauv daim duab hauv qab no, muaj peb qhov chaw ntxiv ntawm cov lus hauv cell C5. Muaj nuj nqi TRIM (TRIM) hauv cell C7 tshem tawm cov chaw no, ntxiv rau ob qhov chaw ntxiv thaum pib thiab xaus ntawm cov kab ntawv.
=TRIM(C5)
=СЖПРОБЕЛЫ(C5)
Piv txwv 3: Yuav ua li cas TSIS tshem qee cov cim tshwj xeeb
muaj nuj nqi TRIM (TRIM) TSIS TXHOB tshem qee cov cim siv los ua qhov chaw. Piv txwv li, qhov chaw tsis tawg yog qhov yuav tshwm sim hauv cov ntawv luam tawm ntawm lub vev xaib. Hauv daim duab hauv qab no, cell C5 muaj ib qho chaw tsis tawg, thiab nws tsis raug tshem tawm.
=TRIM(C5)
=СЖПРОБЕЛЫ(C5)
Koj tuaj yeem rho tawm cov cim tsis tawg ntawm qhov chaw manually los ntawm kev siv lub luag haujlwm RAWS LI (SUBSTITUTE) los yog macro. Tom qab ntawd, thaum peb marathon 30 Excel ua haujlwm hauv 30 hnubKoj yuav kawm ob peb txoj hauv kev los ntxuav cov ntaub ntawv hauv Excel.
