Izindlela ezi-6 zokubuyisela iphuzu nge-semicolon ku-Microsoft Excel

Pin
Send
Share
Send

Abasebenzisi abaningi bohlelo lwe-Excel babhekene nenkinga yokubuyisela amachashazi ngamakhomathi etafuleni. Lokhu kuvame kakhulu ngenxa yokuthi emazweni akhuluma isiNgisi kuwumkhuba ukwehlukanisa izingxenyana zamanani kusuka kwinani ledothi, nakithi, ngethoma. Okubi kunakho konke ukuthi izinombolo ezinechashazi azibonwa kuhlobo lwesiRussia lwe-Excel njengefomethi yenombolo. Ngakho-ke, le nkombandlela ethile yokubuyiselwa esikhundleni ifanelekile. Ake sibheke ukuthi ungawaguqula kanjani amaphuzu abe ngama-semicolons eMicrosoft Excel ngezindlela ezahlukahlukene.

Izindlela zokuguqula iphuzu libe likhefana

Kunezindlela eziningana ezifakazelwe zokuguqula iphuzu libe likhefana ku-Excel. Ezinye zazo zixazululwa ngokuphelele kusetshenziswa ukusebenza kwalolu hlelo lokusebenza, futhi ukusetshenziswa kwabanye, ukusetshenziswa kwezinhlelo zenkampani yangaphandle kuyadingeka.

Indlela yoku-1: Thola Ithuluzi Eliphindwayo

Indlela elula yokushintsha amachashazi ngamakhomphani ukusebenzisa amathuba anikezwa yithuluzi. Thola bese Ufaka esikhundleni. Kepha, udinga ukuqaphela naye. Ngemuva kwakho konke, uma kusetshenziswe ngokungalungile, wonke amaphuzu aseshidi azoshintshwa, ngisho nakulezo zindawo lapho edingeka kakhulu, ngokwesibonelo, ngezinsuku. Ngakho-ke, le ndlela kumele isetshenziswe ngokucophelela.

  1. Ukuba kuthebhu "Ikhaya", eqenjini lamathuluzi "Ukuhlela" kuthebhu chofoza inkinobho Thola nokugqamisa. Kumenyu evelayo, iya entweni Faka esikhundleni.

  2. Kuvulwa iwindi Thola bese Ufaka esikhundleni. Ensimini Thola faka uphawu lw ichashaza (.). Ensimini Faka esikhundleni - uphawu likhefana (,). Chofoza inkinobho "Izinketho".

  3. Usesho olungeziwe bese ukhetha okunye okuvulekile. Ipharamitha ephikisayo "Faka esikhundleni ..." chofoza inkinobho "Ifomathi".

  4. Kuvulwa iwindi lapho singakwazi khona ukusetha ukwakheka kwesitokisi ukuthi siguqulwe, noma ngabe sasinjani ngaphambili. Esimweni sethu, into esemqoka ukusungula ifomethi yedatha yamanani. Kuthebhu "Inombolo" phakathi kwamasethi amafomethi ezinombolo, khetha into "Inombolo". Chofoza inkinobho "Kulungile".

  5. Ngemuva kokuthi sibuyele efasiteleni Thola bese Ufaka esikhundleni, khetha lonke uhla lwamaseli eshidi, lapho kuzodingeka khona ukubuyisela iphuzu ngekhofana. Lokhu kubaluleke kakhulu, ngoba uma ungakhethi uhla, lapho-ke ukuguqulwa kuzokwenzeka kulo lonke ishidi, okungadingekile njalo. Ngemuva kwalokho chofoza inkinobho Esikhundleni Sonke.

Njengoba ukwazi ukubona, ukuphindisela kwaphumelela.

Isifundo: ukufaka umlingiswa ku-Excel

Indlela yesi-2: Sebenzisa umsebenzi we-SUBSTITUTE

Enye indlela yokushintsha isikhathi ngekhoma ukusebenzisa umsebenzi we-SUBSTITUTE. Kodwa-ke, uma usebenzisa lo msebenzi, ukufaka esikhundleni kungenzeki kumaseli okuqala, kodwa kukhonjiswa kukholamu ehlukile.

  1. Khetha iseli, okuzoba elokuqala kwikholamu ukukhombisa idatha eguquliwe. Chofoza inkinobho "Faka umsebenzi", etholakala kwesobunxele bendawo yelebula yomsebenzi.

  2. Umsebenzi wizard uqala. Uhlu olwethulwe ngewindi elivulekile, sibheka umsebenzi SUBSTITUTE. Khetha bese uchofoza inkinobho. "Kulungile".

  3. Iwindi lokuphikisana ngomsebenzi lisebenza. Ensimini "Umbhalo" udinga ukufaka izixhumanisi zeseli lokuqala lekholamu lapho izinombolo ezinamachashazi zitholakala khona. Lokhu kungenziwa ngokumane ukhethe le seli eshidini negundane. Ensimini "Star_ Umxholo" faka iphuzu (.). Ensimini "New_ Umxholo" faka ukhefana (,). Insimu Ukungena_ asikho isidingo sokugcwalisa. Umsebenzi uqobo uzoba nale phethini: "= SUBSTITUTE (cell_address;". ";", ")". Chofoza inkinobho "Kulungile".

  4. Njengoba ukwazi ukubona, esitokisini esisha, inombolo isivele inekhefana esikhundleni ichashaza. Manje sidinga ukwenza umsebenzi ofanayo kuwo wonke amanye amaseli kukholamu. Vele, awudingi ukufaka umsebenzi wenombolo ngayinye, kunendlela esheshayo yokwenza ukuguqulwa. Simi onqenqemeni olungakwesokunxele lweseli eliqukethe idatha eguquliwe. Umaka wokugcwalisa uyavela. Ibambe inkinobho yegundane kwesobunxele, idonsele emngceleni ongezansi wendawo oqukethe idatha okufanele iguqulwe.

  5. Manje sidinga ukwabela ifomethi yenombolo kumaseli. Khetha yonke indawo yedatha eguquliwe. Kubambo oluhle kuthebhu "Ikhaya" ngifuna ibhokisi lamathuluzi "Inombolo". Kuluhlu olwehlayo, shintsha ifomethi ibe yizinombolo.

Lokhu kuqeda ukuguqulwa kwedatha.

Indlela 3: Faka ama-macro

Ungabuyisela iphoyinti ngekhefana ku-Excel usebenzisa i-macro.

  1. Okokuqala, udinga ukunika amandla ama-macros nethebhu "Unjiniyela"uma zingafakwanga nawe.

  2. Iya kuthebhu "Unjiniyela".

  3. Chofoza inkinobho "Okubonakalayo okuyisisekelo".

  4. Ewindini lomhleli elivula, unamathisela ikhodi elandelayo:

    I-Sub Comma_Replacement_ Macro
    Ukukhetha.Replace What: = ".", Replacement: = ","
    Qeda sub

    Vala isihleli.

  5. Khetha indawo yamaseli eshidi ofuna ukuguqula. Kuthebhu "Unjiniyela" chofoza inkinobho IMacros.

  6. Ewindini elivulayo, kuvezwa uhlu lwama-macros. Khetha ohlwini IMacro iphindisela amakhoma ngamachashazi. Chofoza inkinobho Gijima.

Ngemuva kwalokho, ukuguqulwa kwamaphuzu kube amakhoma ebangeni elikhethiwe lamaseli kuyenziwa.

Ukunaka! Sebenzisa le ndlela ngokucophelela. Imiphumela yalesi macro ayinakuguqulwa, ngakho-ke khetha lawo maseli kuphela ofuna ukusisebenzisa kuwo.

Isifundo: ungayakha kanjani iMacro kuMicrosoft Excel

Indlela 4: sebenzisa incwajana

Indlela elandelayo ifaka ukukopisha idatha kusihleli sombhalo esijwayelekile seWindows Notepad, futhi ukuyiguqula kulolu hlelo.

  1. Ku-Excel, khetha indawo yamaseli ofuna ukufaka kuwo iphuzu ngoKhefana. Qhafaza kwesokudla. Kumenyu yokuqukethwe, khetha Kopisha.

  2. Vula incwajana. Sichofoza kwesokudla, futhi ohlwini oluvelayo, chofoza entweni Namathisela.

  3. Chofoza entweni yemenyu Hlela. Kuluhlu olubonakala, khetha Faka esikhundleni. Noma, ungamane uthayiphe inhlanganisela yokhiye kwikhibhodi I-Ctrl + H.

  4. Iwindi lokusesha nokufaka okunye liyavula. Ensimini "Yini" qeda. Ensimini "Kunokuthi" - Ukhefana. Chofoza inkinobho Esikhundleni Sonke.

  5. Khetha idatha eshintshiwe ku-Notepad. Qhafaza kwesokudla, futhi ohlwini, khetha Kopisha. Noma cindezela isinqamuleli sekhibhodi I-Ctrl + C.

  6. Sibuyela e-Excel. Khetha ibanga lamaseli lapho amanani kufanele afakwe endaweni yawo. Sichofoza kukho inkinobho efanele. Kumenyu evela esigabeni Faka Izinketho chofoza inkinobho "Gcina umbhalo kuphela". Noma, cindezela inhlanganisela yokhiye I-Ctrl + V.

  7. Ngalo lonke uhla lwamaseli, setha ifomethi yenombolo ngendlela efanayo naleyo esasiyenza ngaphambili.

Indlela yesi-5: shintsha izilungiselelo ze-Excel

Njengenye yezindlela zokuguqula izikhathi zibe amakhoma, ungasebenzisa ushintsho kuzilungiselelo zohlelo lwe-Excel.

  1. Iya kuthebhu Ifayela.

  2. Khetha isigaba "Izinketho".

  3. Iya kukhomba "Kuthuthukile".

  4. Engxenyeni yezilungiselelo Hlela Izinketho ungahloli into "Sebenzisa abahlukanisi bohlelo". Ensimini esebenze "Ukwehlukaniswa kwezingxenye eziphelele nezinhle kakhulu" qeda. Chofoza inkinobho "Kulungile".

  5. Kepha, imininingwane uqobo ngeke ishintshe. Sizikopisha kwi-Notepad, bese sizinamathisela endaweni efanayo ngendlela ejwayelekile.

  6. Ngemuva kokuthi umsebenzi uqediwe, kunconyelwa ukubuyisela izilungiselelo ze-Excel ngokuzenzakalelayo.

Indlela 6: shintsha izilungiselelo zohlelo

Le ndlela iyefana neyedlule. Kungalesi sikhathi kuphela lapho esingashintshi izilungiselelo ze-Excel. Futhi izilungiselelo zesistimu yeWindows.

  1. Ngomenyu Qala siyangena "Iphaneli Yokulawula".

  2. EPhaneli Yokulawula, iya esigabeni "Iwashi, ulimi nesifunda".

  3. Iya esigatshaneni "Izilimi nezilimi".

  4. Ewindini elivulayo, kuthebhu "Amafomethi" chofoza inkinobho "Izilungiselelo ezithuthukisiwe".

  5. Ensimini "Ukwehlukaniswa kwezingxenye eziphelele nezinhle kakhulu" shintsha ukhefana ube yiphuzu. Chofoza inkinobho "Kulungile".

  6. Kopisha imininingwane nge-Notepad to Excel.

  7. Sibuyisela izilungiselelo zangaphambilini zeWindows.

Iphuzu lokugcina libaluleke kakhulu. Uma ungayenzi, lapho-ke ngeke ukwazi ukwenza imisebenzi ejwayelekile yokubala ngedatha eguquliwe. Ngaphezu kwalokho, ezinye izinhlelo ezifakiwe kukhompyutha kungenzeka zingasebenzi kahle.

Njengoba ukwazi ukubona, kunezindlela ezimbalwa zokubuyisela leli phuzu ngekhoma elikwiMicrosoft Excel. Vele, abasebenzisi abaningi bathanda ukusebenzisa ithuluzi elingasindi kakhulu nelula kule nqubo. Thola bese Ufaka esikhundleni. Kodwa, ngeshwa, kwezinye izimo ngosizo lwayo akwenzeki ukuguqula idatha kahle. Lapho-ke ezinye izisombululo zenkinga zingasiza.

Pin
Send
Share
Send

Okuthunyelwe Popular

https://eifeg.com 2024