Njira 6 zakusinthira mfundoyi ndi semicolon mu Microsoft Excel

Ogwiritsa ntchito ambiri a pulogalamu ya Excel akukumana ndi vuto lakusintha kwa madontho ndi ma komu pagome. Izi nthawi zambiri zimachitika chifukwa chakuti m'maiko olankhula Chingerezi ndimakonda kupatula zigawo zaambala kuchokera pamlingo wokhala ndi dontho, ndipo kwa ife, ndi comma. Choyipa chachikulu, manambala omwe ali ndi kadontho sawadziwika m'mitundu yaku Russia ya Excel ngati mtundu wamitundu. Chifukwa chake, kuwongolera uku ndikofunika. Tiyeni tiwone momwe angasinthire mfundozo kukhala ma semicolons mu Microsoft Excel m'njira zosiyanasiyana.

Njira zosinthira mfundo kukhala comma

Pali njira zingapo zotsimikiziridwa zosinthira mfundo kukhala comma ku Excel. Zina mwazo zimatha kusinthidwa pogwiritsa ntchito pulogalamuyi, ndikugwiritsa ntchito ena, kugwiritsa ntchito mapulogalamu ena.

Njira 1: pezani ndi Chida chosinthira

Njira yosavuta yosinthira madontho ndi ma comma ndikugwiritsa ntchito mwayi womwe chida chimapereka. Pezani ndi Kusintha. Koma, muyenera kukhala osamala naye. Kupatula apo, ngati agwiritsidwa ntchito molakwika, mfundo zonse papepala zidzasinthidwa, ngakhale m'malo omwe amafunikira, mwachitsanzo, m'masiku. Chifukwa chake, njirayi iyenera kugwiritsidwa ntchito mosamala.

1. Kukhala mu tabu "Pofikira", pagulu lazida "Kusintha" pa tepi dinani batani Pezani ndikuwunikira. Pazosankha zomwe zikuwoneka, pitani ku chinthucho M'malo.



2. Zenera limatseguka Pezani ndi Kusintha. M'munda Pezani ikani chikwangwani (.). M'munda M'malo - chikwangwani (,). Dinani batani "Zosankha".



3. Kusaka kowonjezera ndikusintha zosankha zatseguka. Paramu wotsutsa "M'malo ndi ..." dinani batani "Fomu".



4. Windo limatseguka momwe titha kukhazikitsa mawonekedwe a selo kuti lisinthidwe, chilichonse chomwe chidalipo. Kwa ife, chinthu chachikulu ndikukhazikitsa mtundu wamtundu wa zowerengera. Pa tabu "Chiwerengero" pakati pamafomu amitundu, sankhani chinthucho "Numeric". Dinani batani "Zabwino".



5. Pambuyo pobwerera pazenera Pezani ndi Kusintha, sankhani maselo onse osiyanasiyana papepala, pomwe pangafunike kusintha mfundoyo ndi comma. Izi ndizofunikira kwambiri, chifukwa ngati simusankha masanjidwe, ndiye kuti m'malo mwake mudzachitika pepalalo, zomwe sizofunikira nthawi zonse. Kenako, dinani batani Sinthani Zonse.

Monga mukuwonera, m'malo mwake zinthu zidamuyendera bwino.

Phunziro: kulowezedwa kwa ena mu Excel

Njira 2: gwiritsani ntchito SUBSTITUTE ntchito

Njira ina yosinthira nthawi ndi comma ndikugwiritsa ntchito SUBSTITUTE ntchito. Komabe, mukamagwiritsa ntchito, kusinthaku sikubwera m'maselo oyambilira, koma kumawonetsedwa.

1. Sankhani khungu, lomwe lidzakhale loyamba patsamba kuti liwonetse zosintha. Dinani batani "Ikani ntchito", yomwe ili kumanzere komwe kuli chingwe cha ntchito.



2. Ntchito mfiti imayamba. Pamndandanda womwe udawonetsedwa pawindo lotseguka, timayang'ana ntchito SUBSTITUTE. Sankhani ndikudina batani. "Zabwino".



3. Tsamba la mkangano wa ntchito limayambitsa. M'munda "Zolemba" muyenera kuloweza zolumikizana za selo loyamba la mzati momwe manambala okhala ndi madontho amapezeka. Izi zitha kuchitika posankha khungu ili pa pepalalo ndi mbewa. M'munda "Star_akuma" ikani mfundo (.). M'munda "New_xt" ikani comma (,). Mundawo Kulowa_njira palibe chifukwa chofotokozera. Ntchitoyi yokha izikhala ndi mawonekedwe awa: "= SUBSTITUTE (cell_address;". ";", ")". Dinani batani "Zabwino".



4. Monga mukuwonera, mu foni yatsopano, nambalayi ili ndi comma m'malo mopumira. Tsopano tikuyenera kuchita opareshoni chimodzimodzi kwa maselo ena onse m'ndandawo. Zachidziwikire, simukuyenera kuyika ntchito pa nambala iliyonse, pali njira yachangu kwambiri yosinthira. Tikuyimilira m'mphepete lamanja lamanzere a foni yomwe ili ndi zomwe zasinthidwa. Chizindikiro Mukugwira batani lamanzere lakumanzere, ikokerani pansi mpaka kumunsi kwa malowa komwe kuli deta yomwe ingasinthidwe.



5. Tsopano tikuyenera kugawa mtundu wamaselo. Sankhani dera lonse la zomwe zasinthidwa. Pa nthiti mu tabu "Pofikira" kuyang'ana bokosi lazida "Chiwerengero". Pamndandanda wotsitsa, sinthani mawonekedwe kuti akhale manambala.

Izi zimamaliza kutembenuka kwa data.

Njira 3: ikani ma macro

Muthanso kusintha mfundo ndi comma mu Excel pogwiritsa ntchito macro.

1. Choyamba, muyenera kuloleza macros ndi tabu "Wopanga"ngati sanaphatikizidwe ndi inu.



2. Pitani ku tabu "Wopanga".



3. Dinani batani "Zowoneka Zachikulu".



4. Pazenera la mkonzi lomwe limatsegulira, ikani code ili:

   Sub Comma_Replacement_ Macro
Kusankha.Replace What: = ".", Replacement: = ","
Mapeto sub

   Tsekani mkonzi.



5. Sankhani malo omwe ali ndi maselo patsamba lomwe mukufuna kuti musinthe. Pa tabu "Wopanga" dinani batani Macros.



6. Pazenera lomwe limatsegulira, mndandanda wa ma macros ukuperekedwa. Sankhani kuchokera pamndandanda Macro ikusintha ma comas ndi madontho. Dinani batani Thamanga.

Pambuyo pake, kusintha kwa mfundo kuzinthu zamagulu mumaselo osiyanasiyana kumachitika.

Yang'anani! Gwiritsani ntchito njirayi mosamala kwambiri. Zotsatira za macro awa ndiosasinthika, choncho sankhani maselo omwe mukufuna kuti muwagwiritse ntchito.

Phunziro: momwe mungapangire Macro ku Microsoft Excel

Njira 4: gwiritsani ntchito Notepad

Njira yotsatira imaphatikizira kukopera deta mu pulogalamu yolemba Windows Notepad, ndikuwasintha mu pulogalamuyi.

1. Mu Excel, sankhani dera lomwe maselo mukufuna kusintha pamutu ndi comma. Dinani kumanja. Pazosankha zofanizira, sankhani Copy.



2. Tsegulani Notepad. Timadina pomwe, ndipo mndandanda womwe udawonekera, dinani pazinthuzo Ikani.



3. Dinani pazosankha Sinthani. Pamndandanda womwe umawonekera, sankhani M'malo. Kapena, mutha kungolembera mawonekedwe osakanizira pa kiyibodi Ctrl + H.



4. Zosaka ndikusintha zenera zimatseguka. M'munda "Zotani" khazikitsani. M'munda "Kuposa" -. Dinani batani Sinthani Zonse.



5. Sankhani zosintha mu Notepad. Dinani kumanja, ndipo mndandanda, sankhani Copy. Kapena akanikizire njira yachidule Ctrl + C.



6. Tikubwerera ku Excel. Sankhani maselo osiyanasiyana momwe mfundozo ziyenera kusinthidwa. Timadina ndi batani lakumanja. Pazosankha zomwe zimapezeka m'gawolo Ikani Zosankha dinani batani "Sungani zolemba zokha". Kapena, akanikizire kuphatikiza kiyi Ctrl + V.



7. Pazosankha maselo onse, khazikitsani mtundu wa manambala momwe timakhalira kale.

Njira 5: sinthani mawonekedwe a Excel

Monga njira imodzi yosinthira nyengo kukhala ma komasi, mutha kugwiritsa ntchito kusintha kwa makina a pulogalamu ya Excel.

1. Pitani ku tabu Fayilo.



2. Sankhani gawo "Zosankha".



3. Pitani "Zotsogola".



4. Gawo la zoikamo Sinthani Zosankha sakani kanthu "Gwiritsani ntchito olekanitsa dongosolo". M'munda wochititsidwa "Osiyanitsa kwathunthu ndi magawo awiri" khazikitsani. Dinani batani "Zabwino".



5. Koma, zomwezo zokha sizisintha. Timazilemba mu Notepad, ndikuziyika m'malo amodzi munthawi yomweyo.



6. Opaleshoniyo ikamalizidwa, tikulimbikitsidwa kuti mubwezere zoikamo za Excel.

Njira 6: kusintha makonda

Njira iyi ndi yofanana ndi yapita. Pakadali pano pano sitisintha zoikamo za Excel. Ndi makonda a Windows.

1. Kupyola menyu Yambani timalowa "Dongosolo Loyang'anira".



2. Mu Control Panel, pitani ku gawo "Clock, chilankhulo ndi dera".



3. Pitani pagawo laling'ono "Ziyankhulo ndi zigawo".



4. Pazenera lomwe limatsegulira, tabu "Mawonekedwe" dinani batani "Zowongolera Zotsogola".



5. M'munda "Osiyanitsa kwathunthu ndi magawo awiri" sinthani comma kukhala mfundo. Dinani batani "Zabwino".



6. Matulani deta kudzera mu Notepad kupita ku Excel.



7. Timabweza makonda apakale a Windows.

Mfundo yomaliza ndiyofunika kwambiri. Ngati simuchita, ndiye kuti simudzatha kuchita masinthidwe achizolowezi ndi zomwe mwatembenuza. Kuphatikiza apo, mapulogalamu ena omwe aikidwa pakompyuta sangathe kugwira ntchito molondola.

Monga mukuwonera, pali njira zingapo zosinthira mfundoyo ndi comma ku Microsoft Excel. Inde, ogwiritsa ntchito ambiri amakonda kugwiritsa ntchito chida chopepuka kwambiri komanso chosavuta pochita izi. Pezani ndi Kusintha. Koma, mwatsoka, nthawi zina ndi chithandizo chake sizingatheke kutembenuza molondola data. Kenako njira zina zothetsera vutoli zimatha kupulumutsa.