Uma usebenzisa idokhumenti ku-Excel, ngezinye izikhathi kudingekile ukusetha idatha elide noma elifushane. Kungathathwa, kokubili njengombhalo wokubhaliwe kumbhalo, futhi njengedatha. Kodwa inkinga ukuthi akukho uphawu olunjalo kwikhibhodi. Uma uchofoza kumlingisi ekhibhodi efana nedashi, sithola idatha elifushane noma "susa". Ake sithole ukuthi ungasetha kanjani uphawu olungenhla esitokisini ku-Microsoft Excel.
Bheka futhi:
Indlela yokwenza udashi olude eZwini
Ungabeka kanjani i-dash ku-Esccel
Izindlela zokufaka i-dash
Ku-Excel, kunezinketho ezimbili zedeshi: isikhathi eside futhi esifushane. Leli gama libizwa ngokuthi "isilinganiso" eminye imithombo, engokwemvelo uma siqhathanisa nesibonakaliso "-" (i-hyphen).
Uma uzama ukusetha ideshi ende ngokucindezela "-" kwikhibhodi esiyitholayo "-" - uphawu oluvamile "susa". Yini okufanele siyenze?
Empeleni, azikho izindlela eziningi zokufaka i-dash ku-Excel. Zinganiselwe kokubili okukhethwa kukho: iqoqo lezinqamuleli zekhibhodi nokusetshenziswa kwewindi lezinhlamvu ezikhethekile.
Indlela 1: Sebenzisa inhlanganisela yokhiye
Labo abasebenzisi abakholelwa ukuthi ku-Excel, njengeZwini, ungabeka ideshi ngokuthayipha ikhibhodi "2014"bese ucindezela inhlanganisela eyinhloko I-Alt + x, edumazayo: ku-processor ye-tabular, le nketho ayisebenzi. Kodwa enye inqubo isebenza. Gwema ukhiye I-Alt futhi, ngaphandle kokuyikhulula, thayipha kwibalo yenombolo yekhibhodi "0151" ngaphandle izingcaphuno. Ngokushesha nje lapho sikhipha isihluthulelo I-Alt, i-dash ende ivela esitokisini.
Uma, ubambe inkinobho I-Alt, thayipha ngenani le-cell "0150"ke sithola idethi emfushane.
Le ndlela isendaweni yonke futhi ayisebenzi kuphela ku-Excel, kodwa futhi naseZwini, nakweminye imibhalo, ithebula nabahleli be-html. Iphuzu elibalulekile ukuthi abalingiswa abangena ngale ndlela abaguqulwa ibe ifomula, uma wena, ususile isikhombisi kusuka esitokisini sendawo yabo, sithuthele kwenye into yetshe, njengoba kwenzeka ngophawu "susa". Okusho ukuthi, lezi zinhlamvu ziyi-textual, hhayi izinombolo. Sebenzisa emafomulini njengesibonakaliso "susa" ngeke basebenze.
Indlela 2: Ifayili Yezinhlamvu Ezikhethekile
Ungakwazi futhi ukuxazulula le nkinga, usebenzisa iwindi lezinhlamvu ezikhethekile.
- Khetha iseli lapho udinga ukungena khona, bese uhambisa kuthebhu "Faka".
- Bese uchofoza inkinobho. "Uphawu"esitholakala kwibhulogi yamathuluzi "Izimpawu" kwi-tape. Leli yilo elibaluleke kakhulu kubhebhoni kuthebhu. "Faka".
- Ngemuva kwalokho, ukusebenza kwefasitela kubizwa "Uphawu". Yiya kuthebhu layo "Izimpawu Ezikhethekile".
- Ithebhu ekhethekile yabalingiswa ivula. Owokuqala kulolu hlu "Dash eside". Ukusetha leli simboli kuseli elikhethiwe, khetha leli gama bese uchofoza inkinobho Namathiselaetholakala phansi kwefasitela. Emva kwalokho, ungavala ifasitela ukufaka izinhlamvu ezikhethekile. Sichofoza kwisithonjana esivamile sokuvala amawindi ngesimo sesiphambano esimhlophe esigcawini esifomvu esisekhoneni eliphezulu elingakwesokudla kwewindi.
- Idayida elide lizofakwa eshadini kuseli elanduliwe.
I-dash emfushane ngefasitela lomlingisi ifakwa nged algorithm efanayo.
- Ngemuva kokushintshela kuthebhu "Izimpawu Ezikhethekile" iwindi lezinhlamvu khetha igama "Dash iDemo"itholakala okwesibili kuhlu. Bese uchofoza inkinobho Namathisela futhi kusithonjana sefasitela esiseduze.
- I-dash emfushane ifakwa entweni yeshidi ekhethiwe.
Lezi zimpawu zifana ngokuphelele nalabo esifake endleleni yokuqala. Inqubo yokufaka kuphela ehlukile. Ngakho-ke, lezi zibonakaliso nazo azikwazi ukusetshenziselwa amafomula futhi ziyizinhlamvu zombhalo ezingasetshenziswa njengezimpawu zokubhala noma ukuhlabalala kwamaseli.
Sithole ukuthi ukudonswa okude futhi okufushane ku-Excel kungafakwa ngezindlela ezimbili: besebenzisa isinqamuleli sekhibhodi bese usebenzisa iwindi lezinhlamvu ezikhethekile, ukuzulazula kuwo ngokusebenzisa inkinobho ebhethini. Izinhlamvu ezitholakala ngokusebenzisa lezi zindlela zifana ngokufanayo, zinakho ukufaka ikhodi kanye nokusebenza okufanayo. Ngakho-ke, umgomo wokukhetha le ndlela ulula kuphela umsebenzisi ngokwakhe. Njengomkhuba wokubonisa, abasebenzisi abavame ukufaka uphawu lokudaka kumadokhumenti bakhetha ukukhumbula inhlanganisela eyisihluthulelo, ngoba lokhu kukhethwa ngokushesha. Labo abasebenzisa lesi sibonakaliso lapho besebenza ku-Excel bavame ukukhetha ukuthi bafunde inguqulo enembile besebenzisa iwindi lemifanekiso.
