Kutsiva komama nemadots muExcel: 5 nzira

Kupatsanura zvikamu zvakakwana nezvidimbu zvenhamba inomiririrwa sechikamu chedesimali, mutsaura wakasarudzika unoshandiswa: munyika dzinotaura Chirungu idoti, mune dzimwe nguva kazhinji ikoma. Nekuda kwemusiyano uyu, vashandisi veExcel vanowanzotarisana nebasa rekutsiva mamwe mavara neavanoda. Ngatione kuti ungashandura sei makoma kuita madots muchirongwa.

Cherechedza: kana koma ikashandiswa semupatsanuri, ipapo chirongwa hachizogashira nhamba dzine madotsi sezvikamu zvedesimali, zvinoreva kuti hazvigone kushandiswa mukuverenga. Izvi ndezvechokwadi zvakare kune reverse mamiriro.

Method 1: Shandisa Tsvaga uye Kutsiva Tool

Iyi nzira ndiyo inonyanya kufarirwa uye inosanganisira kushandisa chishandiso "Tsvaga uye Tsiva":

1. Chero nzira iri nyore, tinosarudza mutsara wemaseru umo makoma ese anofanira kutsiviwa nemadots. Mukupinza kukuru mubhuroko "Kugadzirisa" tinya pane basa icon "Tsvaga uye sarudza" uye mune zvakarongwa sarudzo tinomira pane iyo sarudzo - “Tsiva”. Iwe unogona zvakare kushandisa iyo keyboard yekudimbudzira kuvhura chishandiso ichi. Ctrl + H.Cherechedza: kana ukasaita sarudzo usati washandisa chishandiso, ipapo kutsvaga nekutsiviwa kwemakoma nenguva kuchaitwa mukati memukati mebepa, izvo zvisingawanzo kudikanwa.
2. Iwindo diki rekuita richaonekwa pachiratidziri. “Tsvaga uye Tsiva”. Isu tinofanirwa kunge tave mune iyo tab “Tsiva” (kana nekuda kwechimwe chikonzero izvi zvisina kuitika, isu tinochinjira kwairi nemaoko). Pano isu tiri mumutengo weparameter “Wana” tsanangura comma sign ye “Yatsiviwa na” – dot sign. Dzvanya bhatani kana wagadzirira “Siva Zvose”kushandisa chishandiso kune ese akasarudzwa maseru.Kudzvanya bhatani rimwechete “Tsiva” ichaita tsvakiridzo imwe chete nekutsiva, kutanga kubva pasero rekutanga renzvimbo yakasarudzwa, kureva kuti inozoda kudzvanywa chaizvo kangani paine zvinotsiva zvinoenderana neakapihwa paramita.
3. Iwindo rinotevera rine ruzivo pamusoro pehuwandu hwekutsiviwa kwakaitwa.
4. Nokudaro, pasina kushanda nesimba, takakwanisa kuisa madotsi panzvimbo yemakoma muchidimbu chakasarudzwa chetafura.

Nzira 2: shandisa "Substitute" basa

Nebasa iri, unogona zvakare kutsvaga nekutsiva imwe hunhu neimwe. Hezvino zvatinoita:

1. Isu tinosimuka muchitokisi chisina chinhu padivi peiyo ine comma (mumutsara mumwechete, asi kwete hazvo mune inotevera). Wobva wadzvanya pane icon "Isa basa" kuruboshwe rweformula bar.
2. Mufafitera rakavhurwa Feature inserts tinya pane iripo chikamu uye sarudza “Mashoko” (zvakakodzerawo “Runyorwa ruzere rwearufabheti”) Muchirongwa chakarongwa, maka mushandisi "SUBSTITUTE", ipapo shandisa OK.
3. Iwindo richaonekwa raunofanirwa kuzadza iyo basa nharo:
   • “Mashoko”: Taura chirevo chesero yekutanga ine koma. Iwe unogona kuita izvi nemaoko nekunyora kero uchishandisa keyboard. Kana, uri mumunda wekuisa ruzivo, tinya pane chaunoda chiri patafura pachayo.
   • "Star_Text": pano, sekunge nebasa “Tsvaga uye Tsiva”, ratidza chiratidzo chinofanira kuchinjwa, kureva koma (asi panguva ino mune quotation marks).
   • “Chinyorwa_ chitsva”: tsanangura chiratidzo chedoti (mumakotesheni).
   • "Nhamba_yekupinda" haisi nharo inodiwa. Muchiitiko ichi, siya munda usina chinhu.
   • Iwe unogona kushandura pakati pebasa nharo nekungodzvanya mukati memunda waunoda kana kushandisa kiyi Tab pa keyboard. Kana zvese zvagadzirwa, tinya OK.
4. Isu tinowana data yakagadziriswa muchitokisi nemushandisi. Kuti uwane mhedzisiro yakafanana kune zvimwe zvinhu zvekoramu, shandisa fill marker. Kuti uite izvi, fambisa pamusoro pekona yezasi yekona yesero nebasa. Pakangochinja chinongedzo kuita chitema plus chiratidzo (izvi ndizvo marker), bata pasi bhatani rekuruboshwe uye worikwevera pasi kune yekupedzisira element yekoromo.
5. Nekuburitsa bhatani rembeva, isu tichabva tangoona mhedzisiro. Inongosara kufambisa iyo data nyowani mutafura, kutsiva iyo yekutanga navo. Kuti uite izvi, sarudza maseru ane mafomula (kana kusarudzwa kwakangoerekana kwabviswa), tinya-kurudyi panzvimbo yamaka uye sarudza chinhu chiri mumenu yemukati inovhura. "Kopa".Unogonawo kushandisa bhatani rakafanana riri mubhokisi rematurusi "Clipboard" mune main tab yechirongwa. Kana kungodzvanya hotkeys Ctrl + C.
6. Iye zvino isu tinosarudza huwandu hwemasero mutafura pachayo, kwatinofanira kunamira iyo data yakakopwa kune clipboard. Tinya-kurudyi panzvimbo yakasarudzwa, mune menyu inovhura mukati "Paste Options" sarudza chiratidzo chine mufananidzo wefolda uye nhamba 123, - kuraira “Inza Zvinokosha”.Cherechedza: Panzvimbo pekusarudza mutsara mune tafura yekubva, unogona kungoenda kune yepamusoro sero (kana kumusoro-kuruboshwe sero, kana tiri kutaura nezvenzvimbo yemakoramu akawanda nemitsara), kutanga kubva kwaunoda kuenda. namatidza iyo data yakakopwa.
7. Makoma ese ari muchikamu atsiviwa nenhambo. Isu hatichada mbiru yekubatsira, uye tinogona kuibvisa. Kuti uite izvi, tinya pazita rayo pane yakachinjika coordinate bar nekurudyi bhatani rembeva uye mune yemukati menyu inovhura, mira pakuraira. "Bvisa". Paunenge uchiita oparesheni, unofanirwa kuve nechokwadi chekuti hapana data rakakosha mumitsara iri pazasi iyi koramu, iyo zvakare ichadzimwa.Imwe nzira ndeyekubvisa zviri mukati memasero. Kuti uite izvi, vasarudze, fonera menyu yemukati nekudzvanya-kurudyi pavari uye sarudza murairo wakakodzera mune iyo rondedzero inovhura.

Method 3: Gadzirisa Excel Options

Ngatiendei kune nzira inotevera, iyo yakasiyana neyakakurukurwa pamusoro apa kuti tichaita zviito kwete munzvimbo yekushanda yepurogiramu (papepa), asi mumamiriro ayo.

Izvo zvinofanirwa kucherechedzwa kuti, iyo iwe yaunoda kuita yekutsiva, inofanirwa kusarudzwa se Nhamba (kana General) kuitira kuti chirongwa chione zvirimo senhamba uye chishandise marongero akataurwa kwavari. Saka ngatitangei:

1. Enda kumenyu "Faira".
2. Sarudza chinhu kubva pane zvakarongwa kuruboshwe "Parameters".
3. Muchikamu “Kuwedzera” usatarise sarudzo "Shandisa masisitimu separators" (parameter group "Edit Options"), mushure mezvo ndima yakatarisana inovhurwa "Integer uye chikamu chinoparadzanisa", umo tinoratidza chiratidzo “point” uye baya OK.
4. Saka, koma achatsiviwa nemadots mumasero ese ane manhamba. Chiito chacho chichaitwa mubhuku rose rekushanda, kwete papepa rino chete.

Nzira 4: Shandisa Custom Macro

Iyi nzira haigoni kunzi yakakurumbira, zvisinei, iripo, saka tichaitsanangura.

Kutanga, isu tinofanirwa kuita gadziriro yekutanga, kureva, gonesa iyo modhi Developer (off by default). Kuti uite izvi, muzvikamu zvepurogiramu muchikamu "Customize Ribhoni" muchikamu chekurudyi chehwindo, tarisa bhokisi riri pedyo nechinhu "Developer". Simbisa shanduko nekudzvanya bhatani OK.

Zvino ngatiburukei kune basa redu guru:

1. Kuchinjira kune tab inooneka "Developer" tinya pachiratidzo chiri kuruboshwe rweribhoni "Visual Basic" (Tool group "code").
2. Hwindo richaonekwa pachiratidziri. Microsoft VB mupepeti. Kuruboshwe, tinya kaviri pane chero pepa kana bhuku. Mumunda unovhura, isa kodhi pazasi uye vhara iyo edhita.

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

   Sarudzo.Siva Chii:=",", Replacement:=".", LookAt:=xlPart, _

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

   ReplaceFormat:=Nhema

   End Sub

3. Isu tinosarudza maseru mune zviri mukati maunoda kutsiva. Wobva wadzvanya pane icon "Macro".
4. Muhwindo rinoonekwa, maka macro yedu uye simbisa kuitiswa kwekuraira nekudzvanya bhatani rakakodzera. Ndapota cherechedza kuti chiito ichi hachikwanisi kuregererwa.
5. Nekuda kweizvozvo, makoma ese ari mumaseru akasarudzwa anotsiviwa nemadotsi.

Cherechedza: nzira iyi inoshanda chete kana poindi yakashandiswa sechisimusi chinoparadzanisa muchirongwa, kureva sarudzo "Shandisa masisitimu separators" (yakurukurwa pamusoro) yakaremara.

Nzira 5: Shandura masisitimu ekombuta

Ngatipedzei nenzira inosanganisira kuita shanduko kune masisitimu eiyo sisitimu yekushandisa pachayo (ngatitarisei muenzaniso weWindows 10).

1. manya Control panel (semuenzaniso, kuburikidza nemutsara kutsvaka).
2. Mukuona mode "Zvidhori zvidiki/hombe" tinya pane applet “Regional Standards”.
3. Mufafitera rinovhurika, tinozozviwana isu tiri mu tab "Fomati"umo tinodzvanya bhatani “Dzimwe sarudzo”.
4. Muhwindo rinotevera mune tab “Nhamba” isu tinogona kutsanangura iyo delimiter hunhu yatinoda kuseta seyakagadzika yehurongwa uye chirongwa cheExcel kunyanya. Muchiitiko chedu, iyi ipfungwa. Dzvanya kana wagadzirira OK.
5. Mushure meizvozvo, makoma ese mumaseru etafura ane data yenhamba (ine fomati - Nhamba or General) achatsiviwa nemadotsi.

mhedziso

Nekudaro, kune nzira dzakati wandei muExcel dzaunogona kushandisa kutsiva koma nenhambo mumaseru etafura. Kazhinji, uku ndiko kushandiswa kweKutsvaga uye Kutsiva chishandiso, pamwe neiyo SUBSTITUTE basa. Dzimwe nzira dzinodiwa muzviitiko zvakasarudzika uye dzinoshandiswa zvishoma kazhinji.