Kusintha madontho ndi makoma mu Excel ndi njira zosiyanasiyana

Nthawi zambiri, ndikugwira ntchito m'matebulo a Excel, pamafunika kusintha madontho ndi koma. Nthawi zambiri izi zimachitika chifukwa chakuti m'mayiko olankhula Chingerezi kadontho amagwiritsidwa ntchito kulekanitsa magawo ang'onoang'ono ndi ang'onoang'ono m'magulu angapo, pamene m'dziko lathu pali comma.

Ndipo zonse zikhala bwino, koma vuto ndilakuti mu mtundu wa Russified wa Excel, deta yokhala ndi dontho sizimawonedwa ngati manambala, zomwe zimapangitsa kuti zikhale zosatheka kuzigwiritsanso ntchito powerengera. Ndipo kuti mukonze izi, muyenera kusintha dontholo ndi koma. Kodi izi zitha bwanji ku Excel, tikambirana m'nkhaniyi.

Njira 1: Kugwiritsa Ntchito Pezani ndi Kusintha Chida

Tiyamba, mwina, njira yosavuta, yomwe imaphatikizapo kugwiritsa ntchito chida “Pezani ndi Kusintha”, pogwira ntchito yomwe muyenera kusamala kwambiri kuti musasinthe mwangozi nthawi ndi koma mu data pomwe izi siziyenera kuchitika (mwachitsanzo, masiku). Nayi momwe zimagwirira ntchito:

1. Pitani ku tabu "Pofikira", ndipo dinani batani "Pezani ndikusankha" (chithunzi cha galasi lokulitsa) mu block "Editing". Mndandanda udzatsegulidwa pomwe timasankha lamulo "Bwezerani". Kapena mutha kungodinanso kuphatikiza makiyi Ctrl + H.
2. Iwindo lidzawonekera pazenera. "Pezani ndi Kusintha M'malo":
   • m'munda polowetsa mtengo wotsutsana ndi chinthucho "Pezani" timalemba chizindikiro "." (mfundo);
   • m’gawo lakuti “Sinthani ndi”, lembani chikwangwanicho "," (koma);
   • kanikizani batani "Parameters".
3. Zosankha zinanso zidzawonekera kuti mupange Pezani ndi Kusintha. Kudina batani "Mtundu" kwa parameter “Kusinthidwa ndi”.
4. Pazenera lomwe likuwoneka, tchulani mtundu wa selo lokonzedwa (lomwe timapeza pamapeto). Malinga ndi ntchito yathu, timasankha "Nambala" mtundu, ndiye dinani OK. Ngati mungafune, mutha kukhazikitsa kuchuluka kwa malo, komanso magulu olekanitsa a manambala pokhazikitsa bokosi loyenera.
5. Zotsatira zake, tidzapezekanso pawindo “Pezani ndi Kusintha”. Apa tikuyenera kusankha malo a ma cell omwe mfundozo zifufuzidwe ndikusinthidwa ndi ma koma. Apo ayi, ntchitoyo idzachitidwa pa pepala lonse, ndipo deta yomwe sikuyenera kusinthidwa ingakhudzidwe. Kusankha ma cell angapo kumachitika ndikukanikiza batani lakumanzere. Dinani pamene mwakonzeka “Sinthani Zonse”.
6. Zonse zakonzeka. Opaleshoniyo idamalizidwa bwino, monga zikuwonetseredwa ndi zenera lazidziwitso ndi kuchuluka kwa zomwe zidasinthidwa.
7. Timatseka mazenera onse (kupatula Excel yokha), pambuyo pake tikhoza kupitiriza kugwira ntchito ndi deta yosinthidwa patebulo.

Zindikirani: kuti musasankhe ma cell angapo mukakhazikitsa magawo pawindo “Pezani ndi Kusintha”, mutha kuzichita pasadakhale, mwachitsanzo, sankhani kaye ma cell, ndiyeno yambitsani chida choyenera kudzera pa mabatani omwe ali pa riboni ya pulogalamuyo kapena kugwiritsa ntchito njira yachidule ya kiyibodi. Ctrl + H.

Njira 2: SUBSTITUTE ntchito

Tiyeni tsopano tione ntchito "SUBSTITUTE", zomwe zimakupatsaninso mwayi wosintha madontho ndi ma koma. Koma mosiyana ndi njira yomwe takambirana pamwambapa, kusinthidwa kwa zikhalidwe sikumachitidwa m'maselo oyambirira, koma kumawonetsedwa m'maselo osiyana.

1. Timapita ku selo lapamwamba kwambiri lazambiri komwe tikukonzekera kuwonetsa deta, kenako timakanikiza batani "Ikani ntchito" (fx) kumanzere kwa formula bar.
2. Pa zenera lotseguka Ntchito Wizards sankhani gulu - "Mawu", momwe timapeza woyendetsa "SUBSTITUTE", sankhani ndikudina OK.
3. Tidzadzipeza tokha pawindo lomwe lili ndi zifukwa zogwirira ntchito zomwe ziyenera kudzazidwa:
   • mu mtengo wa mkangano "Mawu" tchulani makulidwe a selo loyamba lagawo lomwe mukufuna kusintha madontho ndi koma. Mutha kuchita izi pamanja polowetsa adilesi pogwiritsa ntchito makiyi pa kiyibodi. Kapena mutha kudina kaye mbewa mkati mwagawolo kuti mulowetse zambiri, kenako dinani pa cell yomwe mukufuna patebulo.
   • mu mtengo wa mkangano "Star_Text" timalemba chizindikiro "." (mfundo).
   • chifukwa cha mkangano "Zatsopano_mawu" tchulani chizindikiro ngati mtengo "," (koma).
   • mtengo wotsutsana "Nambala_yolowera" sangadzazidwe.
   • dinani mukakonzeka OK.
4. Timapeza zotsatira zomwe tikufuna mu selo losankhidwa.
5. Zimangotsala pang'ono kukulitsa ntchitoyi ku mizere yotsala ya mzerewu. Zachidziwikire, simuyenera kuchita izi pamanja, chifukwa Excel ili ndi ntchito yokwanira yokwanira. Kuti muchite izi, sunthani cholozera kukona yakumanja kwa selo ndi formula, cholozera chikasintha kukhala chizindikiro chakuda chophatikiza (lembani cholembera), gwirani batani lakumanzere ndikuchikokera mpaka pamzere womaliza womwe ukukhudzidwa. kutembenuka kwa data.
6. Zimangokhala kusuntha deta yotembenuzidwa kumalo omwe ali patebulo pomwe iyenera kukhala. Kuti muchite izi, sankhani maselo amzawo ndi zotsatira (ngati kusankha kwachotsedwa pambuyo pa zomwe zachitika kale), dinani kumanja pamalo aliwonse omwe mwasankhidwa ndikusankha chinthucho. "Koperani" (kapena dinani njira yachidule ya kiyibodi Ctrl + C).
7. Kenako timasankha ma cell omwe ali mugawo loyambirira lomwe deta yake yasinthidwa. Timadina kumanja pagawo lomwe lasankhidwa ndi menyu yankhani yomwe imatsegulidwa, muzosankha za phala, sankhani "Values".
8. Pambuyo kumata zomwe zakopedwa, chizindikiro chachidziwitso chidzawonekera pafupi ndi icho. Dinani pa izo ndi kusankha pa mndandanda "Sinthani kukhala nambala".
9. Chilichonse chakonzeka, tili ndi gawo lomwe nthawi zonse zimasinthidwa ndi koma.
10. Chida chogwiritsira ntchito chimagwiritsidwa ntchito WOLEMBEDWA, sichikufunikanso ndipo ikhoza kuchotsedwa kudzera pa menyu yankhani. Kuti muchite izi, dinani kumanja pazigawo zomwe zili pa bar yopingasa yolumikizira ndikusankha lamulo kuchokera pamndandanda womwe ukuwoneka. "Chotsani".
11. Zochita pamwambapa, ngati zingafunike, zitha kuchitidwa molingana ndi magawo ena agawo loyambira.

Njira 3: Kugwiritsa Ntchito Macro

Macros imakulolani kuti musinthe kadontho ndi koma. Umu ndi momwe zimachitikira:

1. Choyamba muyenera kuonetsetsa kuti tabu ndiyoyambitsidwa "Developer"yomwe imayimitsidwa mwachisawawa mu Excel. Kuti mutsegule tabu yomwe mukufuna, pitani ku menyu "Fayilo".
2. Pamndandanda womwe uli kumanzere, pitani ku gawolo "Parameters".
3. Pazosankha za pulogalamuyo, dinani gawolo "Sinthani Riboni", pambuyo pake, kumanja kwawindo, ikani chizindikiro kutsogolo kwa chinthucho "Developer" ndipo dinani OK.
4. Sinthani ku tabu "Developer"momwe timadina pa batani "VisualBasic".
5. Mu mkonzi, dinani pa pepala lomwe tikufuna kusintha, pawindo lomwe limatsegula, ikani kachidindo pansipa, ndikutseka mkonzi:

   Sub Макрос_замены_точки_на_запятую()

   Kusankha.Sinthani Zomwe:=".", Kusintha:=".", LookAt:=xlPart, _

   SearchOrder:=xlByRows, MatchCase:=Zabodza, SearchFormat:=Zabodza, _

   ReplaceFormat:=Zabodza

   mapeto Sub

6. Tsopano sankhani ma cell angapo papepala pomwe tikukonzekera kusinthanso, kenako dinani batani "Macro" zonse mu tabu yomweyo "Developer".
7. Zenera lidzatsegulidwa ndi mndandanda wa macros, momwe timasankha "Macro_replace_dot_by_comma" ndikukankha "Thamanga".
8. Zotsatira zake, tidzalandira ma cell omwe ali ndi data yosinthidwa, momwe madontho asinthidwa ndi ma koma, zomwe ndizomwe timafunikira.

Njira 4: Kugwiritsa ntchito Notepad

Njirayi imayendetsedwa ndi kukopera deta mu mkonzi womangidwa mu Windows opaleshoni dongosolo. Notebook zakusintha pambuyo pake. Ndondomeko ikuwonetsedwa pansipa:

1. Poyamba, timasankha ma cell angapo omwe timafunikira kusintha madontho ndi koma (tiyeni tiganizire ndime imodzi monga chitsanzo). Pambuyo pake, dinani kumanja pa malo aliwonse omwe mwasankhidwa ndikusankha lamulo kuchokera pamenyu yomwe imatsegula. "Koperani" (kapena mutha kugwiritsa ntchito njira yachidule ya kiyibodi Ctrl + C).
2. Thamangani Notebook ndikumata zomwe mwakoperazo. Kuti muchite izi, dinani kumanja ndikusankha lamulo kuchokera pamenyu yotsitsa. "Ikani" (kapena gwiritsani ntchito kuphatikiza Ctrl + V).
3. Pamwambamwamba kapamwamba, dinani "Sinthani". Mndandanda udzatsegulidwa, momwe timadina pa lamulo "Bwezerani" (kapena dinani hotkeys Ctrl + H).
4. Zenera laling'ono lolowa m'malo lidzawonekera pazenera:
   • m'munda kuti mulowetse mtengo wa parameter "Chani" kusindikiza khalidwe "." (mfundo);
   • ngati mtengo wa parameter "Bwanji" ikani chizindikiro "," (koma);
   • Kankhani “Sinthani Zonse”.
5. Tsekani zenera lolowa m'malo. Sankhani deta yosinthidwa, kenako dinani kumanja ndikusankha lamulo "Koperani" mu menyu yankhani yomwe imatsegulidwa (mutha kugwiritsanso ntchito Ctrl + C).
6. Tiyeni tibwerere ku Excel. Timayika malo omwe mukufuna kuyika zomwe zasinthidwa. Kenako dinani kumanja pagulu lomwe mwasankha ndikusankha lamulo “Sungani mawu okha” muzosankha zoyika (kapena dinani Ctrl + V).
7. Zimangotsala kuti muyike mawonekedwe a cell ngati "Nambala". Mutha kusankha mubokosi lazida "Nambala" (tab "Pofikira") podina mtundu wamakono ndikusankha yomwe mukufuna.
8. Ntchitoyi idamalizidwa bwino.

Njira 5: Kukhazikitsa Zosankha za Excel

Pogwiritsa ntchito njirayi, tifunika kusintha makonzedwe ena a pulogalamu.

1. Pitani ku menyu "Fayilo", pomwe timadina pagawolo "Parameters".
2. Pazigawo za pulogalamu yomwe ili pamndandanda womwe uli kumanzere, dinani gawolo "Zowonjezera"… Mu zoikamo chipika "Sintha Zosankha" chotsani bokosi loyang'ana pafupi ndi zosankha "Gwiritsani ntchito zolekanitsa dongosolo". Pambuyo pake, minda yolowetsa zilembo monga olekanitsa imatsegulidwa. Monga cholekanitsa cha magawo onse ndi magawo, timalemba chizindikirocho "." (dontho) ndikusunga zoikamo mwa kukanikiza batani OK.
3. Sipadzakhala zosintha zowoneka patebulo. Choncho, timapitirira. Kuti muchite izi, koperani deta ndikuyiyika mu Notebook (tiyeni tione chitsanzo cha ndime imodzi).
4. Kuchotsa deta kuchokera polembapo ndikulowetsanso mu tebulo Excel pamalo omwewo pomwe adakopera. Mayendedwe a data asintha kuchokera kumanzere kupita kumanja. Izi zikutanthauza kuti tsopano pulogalamuyo ikuwona izi ngati manambala.
5. Bwererani ku zoikamo za pulogalamu (gawo "Zowonjezera"), pomwe timabwezera bokosi loyang'ana moyang'anizana ndi chinthucho "Gwiritsani ntchito zolekanitsa dongosolo" m'malo mwake ndikudina batani OK.
6. Monga mukuwonera, madontho adasinthidwa ndi pulogalamu ndikuyika makoma. Musaiwale kusintha mtundu wa data kukhala "Nambala" ndipo mutha kugwira nawo ntchito mopitilira apo.

Njira 6: Zokonda pa System

Ndipo potsiriza, taganizirani njira ina yofanana ndi yomwe tafotokozayi, koma imaphatikizapo kusintha makonda osati a Excel, koma a Windows opaleshoni.

1. Timalowa Gawo lowongolera m'njira iliyonse yabwino. Mwachitsanzo, izi zikhoza kuchitika kudzera Searchpolemba dzina lomwe mukufuna ndikusankha njira yomwe mwapeza.
2. Khazikitsani mawonekedwe ngati zithunzi zazing'ono kapena zazikulu, kenako dinani gawolo “Regional Standards”.
3. Zenera zoikamo dera adzaoneka, mmene, pokhala mu tabu "Mtundu" dinani batani "Zokonda zowonjezera".
4. Muwindo lotsatira ndi zoikamo mtundu, tikuwona chizindikiro "Integer/Decimal Separator" ndi mtengo wake. M'malo mwa koma, lembani nthawi ndikusindikiza OK.
5. Mofanana ndi njira yachisanu yomwe takambirana pamwambapa, timakopera deta kuchokera ku Excel kupita Notebook ndi kumbuyo.
6. Timabwezeretsa zokonda zamtundu momwe zilili. Izi ndizovuta, chifukwa mwina zolakwika zitha kuchitika pakugwiritsa ntchito mapulogalamu ndi zida zina.
7. Madontho onse mugawo lomwe tinkagwirapo adasinthidwa ndi koma.

Kutsiliza

Chifukwa chake, Excel imapereka njira 5 zosiyanasiyana, zomwe mungagwiritse ntchito kuti musinthe madontho ndi ma koma, ngati pakufunika kutero panthawi yantchito. Kuphatikiza apo, mutha kugwiritsa ntchito njira ina, yomwe imaphatikizapo kusintha makonda a Windows opaleshoni yokha, momwe Excel imayikidwa.