Yuav ua li cas los daws ib qho teeb meem hauv Excel "Thawj tsab ntawv peev"

Ntau tus neeg nug lawv tus kheej: yuav ua li cas ua thawj tsab ntawv hauv Excel peev? Xws li ib qho teeb meem, tseeb, tshwm sim heev ntau. Piv txwv, cov neeg siv ntawm phau ntawv no ua tsis muaj tseeb cov ntaub ntawv, ua lub npe los ntawm ib tsab ntawv me me, cia ntxiv cov chaw, yuam kev, tsis ua hauj lwm, uas ua rau qhov tseeb tias uniformity yog thaum kawg ua kom tiav.

Tsab ntawv xov xwm no tau muab rau cov cuab yeej hauv Excel spreadsheet qhov kev pab cuam los ntawm Microsoft muab los ntawm tus tsim tawm los tswj cov peev thiab cov tsiaj ntawv loj ntawm lawv qhov kev pom zoo.

Excel nta

Nyob rau hauv Excel, muaj cov nram qab no npaj txhij ua haujlwm ua haujlwm nrog cov hlua:

• = TIV THAIV (ntawv nyeem lossis hauv xov tooj nrog cov ntawv nyeem) - txhais tag nrho cov ntawv nkag (lossis cov ntawv nyeem ntawm lub xovtooj ntawm xaiv) rau lub npe;
• = ZAJ LUS (ntawv nyeem lossis hauv xov tooj nrog cov ntawv nyeem) - txhais tag nrho cov ntawv sau (lossis cov ntawv nyeem ntawm lub tshuab xaiv) kom txo tau;
• = PROPONACH (ntawv nyeem lossis hauv xov tooj nrog cov ntawv nyeem) - qhov kev ua no yuav pib siv thawj tsab ntawv ntawm txhua lo lus (chaw-cais) ntawv, thiab ua cov ntawv seem me me.

Khiav cov haujlwm hauv Excel "Thawj tsab ntawv yog qhov loj", raws li peb pom, tsis muaj peev xwm ua tau. Ua li no, peb siv cov kev npaj ua tiav, tab sis xav txog qhov no me ntsis tom qab. Ua ntej, peb mam li tshawb xyuas cov peev thiab peev hauv Excel raws li cov haujlwm saum toj no.

Ua haujlwm nrog lub zog PROPRESS, STRONCH thiab PROPONACH

Yuav kom tshawb xyuas txhua yam ntawm peb qhov kev khiav dej num, peb yuav nkag mus rau kab A2 ntawm daim ntawv ua haujlwm hauv Excel: "Apple Antigen Enchantment" (tshwj xeeb tshaj yog tso cai rau ib daim ntawv ntxiv rau kev ua haujlwm). Hauv kab ntawv tom ntej, sau cov qauv hauv qab no thiab muab cov piv txwv:

Raws li koj tau pom, txhua yam haujlwm ua haujlwm raws li qhov kev piav qhia.

Pom zoo, nws yuav yooj yim, uas nyob rau hauv Excel thawj tsab ntawv ntawm lub peev ua xws li ib tug yooj yim xaiv ntawm ib tug muaj nuj nqi, tab sis, hmoov tsis, qhov no yog tsis yooj yim sua. Peb yuav tsum tsim kom tau qhov formula peb xav tau ... Cia xaiv ib seem rau qhov no.

Excel: thawj thawj tsab ntawv

Yuav kom daws tau qhov hauj lwm no, nws yog ib qho tsim nyog yuav tsum rhuav tshem nws tawm rau lwm theem. Hauv qhov no, peb tuaj yeem paub qhov txawv ntawm cov hauv qab no:

1. Xaiv thawj tsab ntawv ntawm cov ntawv nyeem. Tib lub sij hawm, nws yog ib qho tsim nyog yuav tsum tau coj mus rau hauv tus account hais tias feem ntau cov neeg siv ua ntxiv tej qhov chaw ua ntej nkag mus rau hauv cov ntawv nyeem. Rho tawm cov nruam ntxiv nrog kev pab cuam ntawm BLOCK kev ua haujlwm (text), thiab xaiv thawj tsab ntawv - qhov LEVSIMV (text; [tus lej cim]) nrog ob qhov sib npaug sib npaug 1 (nws yog xaiv los ntawm lub neej, ces koj tuaj yeem tso nws).
2. Xaiv thawj tsab ntawv nrog kev pab cuam ntawm qhov ua haujlwm PROPOSAL tham hauv seem dhau los thiab txhais nws rau hauv lub npe ntawv.
3. Vim tias peb xav tau ua haujlwm hauv Excel, "Thawj tsab ntawv capital", qhov no txhais tau hais tias cov seem ntawm cov ntawv nyeem yuav yog qhov loj. Ua li ntawd thaum nws ua tau, tam sim no peb yuav tsum xa cov ntawv ntxiv rau thawj tsab ntawv. Ua li no, peb siv tau cov PRIMOV kev ua haujlwm (text, [number of characters]) uas xaiv cov zauv cim ntawm cov cim los ntawm qhov kawg ntawm cov ntawv. Thiab zoo li cas, hais lus zoo, yog qhov zoo tshaj plaws? Koj xav tau ntau npaum li qhov ntev ntawm txoj hlua rho tus ua cim thawj, uas yog, -1. Tom qab ua tiav cov kauj ruam no, cov txiaj ntsig yuav tsum tau muab txo kom qis rau ib daim ntawv ua lag luam.
4. Nws tseem mus txuas rau cov ntsiab lus ntawm qhov thib ob thiab peb cov ntsiab lus nrog lub ampersand (&).

Tag nrho cov sib lawv liag no nyob hauv lub rooj, rau qhov pom tseeb, peb ntxig rau ob peb qhov chaw ntxiv nyob rau hauv pem hauv ntej ntawm cov ntawv nyeem "txiv apples thiab antonovka tshiab".

Raws li koj tau pom, daws qhov teeb meem nyob rau hauv Excel "Thawj tsab ntawv ntawm lub npe" ua tsis tau li nyuaj, qhov tseem ceeb tshaj plaws yog los qhia tag nrho cov zajlus kom sib lawv liag.