Umshini noma Umbhalo Uhlamvu Olucacile Nokusetshenziswa ku-Excel

I-string string, eyaziwa nangokuthi iyunithi yocingo noma nje njengombhalo iqoqo lezinhlamvu ezisetshenziswe njengedatha ohlelweni lwesipredishithi.

Nakuba izintambo zombhalo zivame ukuba namazwi, zingase zihlanganise nezinhlamvu ezifana nalezi:

• izincwadi
• izinombolo
• izinhlamvu ezikhethekile njengezikhathi (.), uphawu lwe-dash ( - ), noma isibonakaliso senombolo ( # )

Ngokuzenzakalelayo, izintambo zombhalo zishiywe ngokulandelana esitokisini ngenkathi idatha yocingo ihambelana ngakwesokudla.

Ukufometha Idatha njengombhalo

Nakuba izintambo zombhalo zivame ukuqala ngencwadi yama-alfabhethi, noma yikuphi ukungena kwedatha okufomathiwe njengombhalo okuhunyushwa njengezintambo.

Ukuguqula Amanani Namafomu Okubhalwe Nge-Apostrophe

I-string string ingadalwa nakuzo zombili i-Excel ne-Google Spreadsheets ngokufaka i-apostrophe ( ' ) njengomlingiswa wokuqala wedatha.

I-apostrophe ayibonakali esitokisini kodwa iphoqa uhlelo ukuthi lihumushe noma yiziphi izinombolo noma izimpawu ezifakwe ngemuva kwe-apostrophe njengombhalo.

Isibonelo, ukungena ifomula efana ne- = A1 + B2 njengeyunithi yocingo, thayipha:

'= A1 + B2

I-apostrophe, ngenkathi ingabonakali, ivimbela uhlelo lwesipredishithi ekuchazeni ukungena njengefomula.

Ukuguqula izintambo zombhalo kumininingwane yenombolo ku-Excel

Ngezinye izikhathi, izinombolo ezikopishiwe noma ezingeniswe kuspredishithi ziguqulwa zibe idatha yombhalo. Lokhu kungabangela izinkinga uma idatha isetshenziswa njengengxabano kwezinye izinhlelo zokusebenza ezakhelwe ngaphakathi njenge- SUM noma i- AVERAGE .

Izinketho zokulungisa le nkinga zihlanganisa:

Indlela yoku-1: Namathisela okukhethekile ku-Excel

Ukusebenzisa okunamathiselwe okhethekile ukuguqula idatha yombhalo kuya ezinombolweni kulula futhi njengenzuzo ukuthi idatha eguqulwe ihlala endaweni yayo yangempela - ngokungafani nomsebenzi we-VALUE odinga idatha eguquliwe ukuba ihlale endaweni ehlukile idatha yedatha yokuqala.

Option 2: Sebenzisa Inkinobho Yephutha ku-Excel

Njengoba kuboniswe esithombeni ngenhla, inkinobho yephutha noma inkinobho yokuhlola i- Error ku-Excel iyinxantathu encane ephuzi evela eceleni kwamaseli aqukethe amaphutha wedatha - njengalapho idatha yombhalo ifomathiwe njengombhalo isetshenziswe kwifomula. Ukusebenzisa Inkinobho Yephutha ukuguqula idatha yombhalo ezinombolweni:

1. Khetha iseli (ama) aqukethe idatha embi
2. Chofoza inkinobho yephutha eceleni kweseli ukuvula imenyu yemongo yezinketho
3. Chofoza ku- Convert to Number kwimenyu

Idatha kumaseli akhethiwe kufanele aguqulwe abe izinombolo.

Ukubambisana nezintambo zombhalo ku-Excel nama-Google Spreadsheets

Ku-Excel ne-Google Spreadsheets, uhlamvu lwama-ampersand (&) lungasetshenziswa ukujoyina ndawonye noma ukunciphisa izintambo zombhalo ezisezindlini ezihlukile endaweni entsha. Isibonelo, uma ikholomu A iqukethe amagama okuqala nekholomu B amagama okugcina abantu ngabanye, amangqamuzana amabili wedatha angahlanganiswa ndawonye kukholomu C.

Ifomula ezokwenza lokhu = = (A1 & "" & B1).

Qaphela: umqhubi we-ampersand akafaki ngokuzenzekelayo izikhala phakathi kwamachungechunge wombhalo abhalwe phansi ngakho kumele afakwe efomini ngesandla. Lokhu kwenziwa ngokuzungeze umlingisi wesikhala (wangena usebenzisa ibha yesikhala ekhibhodi) ngamamaki okucaphuna njengoba kuboniswe kwifomula ngenhla.

Enye indlela yokujoyina izintambo zombhalo ukusebenzisa i- CONCATENATE umsebenzi .

Ukufakela idatha yombhalo kumaCell Multiple nge Umbhalo kuya Kumakholomu

Ukwenza okuphambene nesitatimende - ukwehlukanisa iseli elilodwa yedatha zibe ngamaseli amabili noma ngaphezulu ahlukene - I-Excel inombhalo wezinhlamvu zekholomu. Izinyathelo zokufeza lo msebenzi ziyi:

1. Khetha ikholomu yamaseli aqukethe idatha yombhalo ohlangene.
2. Chofoza kwimenyu yedatha yemenyu ye- Ribbon .
3. Chofoza kumbhalo kuya kumakholomu ukuze uvule umbhalo wokuguqula umbhalo kumakholomu wekholomu.
4. Ngaphansi kohlobo lwe-Original lwedatha yesinyathelo sokuqala, chofoza u- Delimited , bese uchofoza Okulandelayo.
5. Ngaphansi kwesigaba sesi-2, khetha i-separator yombhalo oqondile noma i- delimiter yedatha yakho, njengeThabhu noma isikhala, bese uchofoza Okulandelayo.
6. Ngaphansi kwesinyathelo sesi-3, khetha ifomethi efanelekile ngaphansi kwefomethi yedatha yekholomu , njengeGenerali.
7. Ngaphansi kwenketho ye-inkinobho Ethuthukile , khetha izilungiselelo ezihlukile zehlukanisi ye- Decimal kanye ne- Separator separator , uma okungahleliwe - isikhathi kanye ne-comma ngokulandelana - akulungile.
8. Chofoza Qedela ukuvala iwididi bese ubuyela ekhasini lokusebenzela.
9. Umbhalo kukholomu ekhethiwe kufanele manje uhlukaniswe ngamakholomu amabili noma ngaphezulu.