Kodi kupanga kalata yoyamba likulu mu kupambana

Anonim

Chilembo chachikulu ku Microsoft Excel

Nthawi zambiri, chofunika kuti kalata yoyamba mu tebulo pa tebulo anali lotchedwa (likulu). Ngati wosuta poyamba olakwa analowa makalata lowercase kapena kukopera deta ku gwero lina mu kupambana, imene mawu onse anayamba ndi kalata yaing'ono, mungathere lalikulu kwambiri kuchuluka kwa nthawi ndi nthawi kubweretsa kuoneka tebulo kwa anakhumba boma. Koma mwina kupambana ali zipangizo wapadera mungathe automate njirayi? Indedi, pulogalamu ali ndi ntchito kusintha zilembo lowercase kuti likulu. Tiyeni tione mmene ntchito.

Ndondomeko kusintha kwa kalata yoyamba kwa mutuwo

Inu sitiyenera kuyembekezera kuti kupambana pali batani osiyana ndi kuwonekera limene, mukhoza basi kutembenukira chingwe kalata kwa udindowo. Kuti tichite zimenezi, mudzakhala ndi ntchito ntchito, ndi angapo nthawi imodzi. Komabe, mu Mulimonsemo, njira iyi ndi chidwi ndithu tidzalipira mtengo zosakhalitsa kuti padzafunika kuti pamanja kusintha deta.

Njira 1: M'malo kalata yoyamba mu selo pa mutu

Kuti athetse ntchito, ntchito yaikulu ntchito m'malo, komanso ntchito padera kwa dongosolo loyamba ndi lachiwiri m'kaundula ndi Levsimv.

  • The Sinthanitsani ntchito m'malo munthu wina kapena m'gulu la anthu ena, malinga ndi mfundo mwachindunji;
  • Mwalamulo - zimapangitsa makalata likulu, womwe ndi likulu, kodi tiyenera;
  • Levsimv - MBABWERERA mwachindunji nambala ya zilembo za lembalo mchipindamo.

Ndiko kuti, potengera izi ya ntchito, mothandizidwa ndi Levsimv, tidzakhala ndalama kalata yoyamba kwa selo yake, ntchito woyendetsa, tidzapanga izo zazikulu, kenako m'malo ndi kugwira ntchito m'malo lowercase kalata ndi zazikulu.

The Chinsinsi ambiri a opaleshoni lidzaonekera izi:

= Sinthanitsani (old_text; Nach_Post; number_ chizindikiro; yoyenera (Levsimv (lemba; number_names)))

Koma ndi bwino kuganizira zonse pa yeniyeni chitsanzo. Choncho, tili ndi tebulo anamaliza imene mawu onse olembedwa ndi kalata yaing'ono. Tili chizindikiro choyamba mukachipinda ndi mayina kuti mutuwo. Selo loyamba ndi labambo ali ndondomeko ya B4.

  1. Mu malo aliwonse ufulu wa pepala ili kapena pa pepala lina, kulemba mfundo zotsatirazi:

    = Sinthanitsani (b4; 1; 1; yoyenera (Levsimv (B4; 1)))

  2. Fomu ya Microsoft Excel

  3. Kuti deta ndondomeko ndi kuona zotsatira zake, dinani ENTER batani pa kiyibodi. Monga mukuonera, tsopano muchipindachi, mawu oyamba imayamba ndi likulu kalata.
  4. Zotsatira za kuwerengetsa mu Microsoft Excel

  5. Timakhala cholozera ku ngodya wamanzere wa khungu ndi chilinganizo ndi ntchito kudzazidwa chikhomo kutengera njira mu maselo m'munsi. Tiyenera kutengera izo ndendende kotero udindo pansi mmene maselo ambiri ndi mayina ndi chake tebulo zikuchokera gwero.
  6. Kudzaza chikhomo ku Microsoft Excel

  7. Monga mukuonera, anapatsidwa kukamba za mu chilinganizo wachibale, osati malire, kukopera zinachitika ndi olakwika. Choncho, nkhani za malo awa mu dongosolo udindo anasonyeza mwa maselo m'munsi, komanso ndi likulu kalata. Tsopano tiyenera kumanga zotsatira mu tebulo gwero. Sankhani zosiyanasiyana ndi mitunduyi. Ine alemba pa mbewa batani bwino ndi kusankha "Koperani" menyu nkhani.
  8. Kukopera deta ku Microsoft Excel

  9. Pamenepo ife kuunikila maselo pachiyambi ndi maina tebulo. Itanani menyu omwe ali ndi vuto podina batani la mbewa. Mu "Ikani magawo" chipika, sankhani item "Zinthu", umene ankayimiridwa ngati zithunzi ndi manambala.
  10. Kulowetsa makhalidwe Microsoft Excel

  11. Monga mukuonera, zitatha izo, deta tiyenera akhala anaikapo mu maudindo gwero la gome. Pa nthawi yomweyo, lowercase makalata Mawu oyamba maselo n'kuyamba ndi zazikulu. Tsopano, osati kusokoneza maonekedwe a pepala, muyenera kuchotsa maselo ndi mitunduyi. Ndikofunikira kuchotsa kaya inu munachita kutembenuka pa pepala limodzi. Ife kuunikila yake osiyanasiyana, Dinani kudina-kawiri ndi menyu nkhani, siyani kusankha pa "Chotsani ..." katunduyo.
  12. Kuchotsa maselo mu Microsoft Excel

  13. Mu otsika kukambirana bokosi limene limapezeka, inu anapereka lophimba kuti "chingwe" malo. Dinani pa batani la "OK".

Pambuyo pake, deta owonjezera adzakhala kutsukidwa, ndipo ife tidzatenga moti zimatheka: uliwonse tebulo selo, mawu oyamba imayamba ndi likulu kalata.

chifukwa okonzeka mu Microsoft Excel

Njira 2: Aliyense mawu ndi likulu kalata

Koma pali milandu pamene kuli kofunikira kuti osati mawu oyamba mu khungu, kuyambira ndi likulu kalata, koma ambiri, mawu aliwonse. Chifukwa cha zimenezi, palinso ntchito osiyana, ndipo zimakhala zosavuta kuposa m'mbuyomu. Mbali imeneyi imatchedwa propnant. malembedwe ake ndi lophweka:

= KONZEKERETSANI (addresschair)

Pa chitsanzo chathu, ntchito adzayang'ana motere.

  1. Sankhani malo ufulu wa pepalalo. Dinani pa "Inter Apple".
  2. Sinthani ku mbuye wa ntchito mu Microsoft Excel

  3. Mu mfiti ukugwirira ntchito ya ntchito, tiyembekezera kuti "Raknach". Tikapeza dzina ili, ife kuonetsetsa kuti ndi kumadula pa "Chabwino" batani.
  4. Mwini ntchito ku Microsoft Excel

  5. Khomo lachikangano limatseguka. Tiika cholozera m'munda "Text". Sankhani selo loyamba ndi labambo mu tebulo gwero. Pambuyo adiresi yake kugunda mtsutso zenera, alemba pa Chabwino batani.

    Mkangano zenera NKHANI Microsoft Excel

    Pali njira ina kanthu kukulozani ntchito mfiti. Kuti tichite zimenezi, tiyenera, monga pa njira yapita, kulowa ntchito ya pamanja selo ndi kujambula wa ndondomeko gwero deta. Pankhaniyi, kulowa limeneli adzakhala ndi mawonekedwe zotsatirazi:

    = KONZEKERETSANI (B4)

    Ndiye muyenera kupitiriza ENTER batani.

    Kusankha yeniyeni njira zikudalira pa wosuta. Anthu owerenga amene si ntchito kusunga mitunduyi zosiyanasiyana mutu, mwachibadwa, n'kosavuta zinthu mothandizidwa ndi mfiti ntchito. Pa nthawi yomweyo, anthu ena amakhulupirira kuti mofulumira kwambiri kuposa kulowa Buku woyendetsa.

  6. Kaya njira anasankhidwa, mu chipinda tinalandira chotsatira kuti tinkafunika. Tsopano mawu onse atsopano mu selo imayamba ndi likulu kalata. Pamene nthawi yotsiriza, kutengera chilinganizo pa maselo pansipa.
  7. Kukopera formula ku Microsoft Excel

  8. Pambuyo kutengera chifukwa ntchito menyu nkhani.
  9. Koperani Zotsatira mu Microsoft Excel

  10. Ikani deta mwa "Zinthu" item Ikani magawo mu tebulo gwero.
  11. Kuika mu Microsoft Excel

  12. Chotsani mfundo zokhwima kudzera menyu nkhani.
  13. kuwerengetsera Chotsani mu Microsoft Excel

  14. Mu zenera latsopano, kutsimikizira kuchotsa m'mizere ndi kuika lophimba kuti malo oyenera. Dinani batani la "OK".

Pamenepo ife udzapeza m'pang'ono gwero tebulo, koma mawu onse maselo ankachitira tsopano sizinatchulidwe ndi likulu kalata.

Tebulo lokonzekera mu Microsoft Excel

Monga mukuonera, ngakhale kuti kusintha misa makalata lowercase ku likulu mu kupambana sikutheka kutchedwa ndondomeko ya pulayimale, Koma zimakhala zosavuta ndi yabwino kuposa kusintha zilembo pamanja, makamaka pamene pali zambiri a iwo. The ma aligorivimu pamwamba kuteteza osati mphamvu ya wosuta, koma nthawi chidali ndi nthawi. Choncho, zofunika kuti wosuta okhazikika kupambana akhoza kugwiritsa ntchito zida izi mu ntchito yake.

Werengani zambiri