Mzere kapena Malembo Mphindi Tanthauzo ndi Ntchito mu Excel

Mndandanda wa malemba, wotchedwanso chingwe kapena chabe monga malemba ndi gulu la zilembo zomwe zimagwiritsidwa ntchito ngati deta mu pulogalamu ya spreadsheet.

Ngakhale makina a malemba nthawi zambiri amakhala ndi mawu, angaphatikizepo malemba monga:

• makalata
• nambala
• zolemba zapadera monga nthawi (.), chizindikiro cha dash ( - ), kapena chizindikiro cha nambala ( # )

Mwachisawawa, zingwe zolembera zimasiyidwa mu selo pomwe deta ya data ikugwirizana nayo.

Kupanga Deta monga Text

Ngakhale makina a malemba nthawi zambiri amayamba ndi kalata ya zilembo, zolemba zonse zomwe zasinthidwa monga malembo amatanthauzidwa ngati chingwe.

Kusintha Numeri ndi Mafomu Kulemba ndi Atumwi

Mndandanda wa malemba ukhoza kukhazikitsidwa ku Excel ndi Google Spreadsheets polemba apostrophe ( ' ) monga khalidwe loyamba la deta.

Apo apostrophe sichiwoneka mu selo koma imalimbikitsa pulogalamuyo kutanthauzira chiwerengero kapena zizindikiro zilizonse zitatha pambuyo pa apostrophe ngati malemba.

Mwachitsanzo, kulowetsani ndondomeko monga = A1 + B2 ngati chingwe cholembera, lembani:

'= A1 + B2

Apo apostrophe, pamene sichiwoneke, imalepheretsa pulogalamu ya spreadsheet kuti itanthauzire cholowera ngati njira.

Kusintha Zimalumikizo za Malemba ku Data Nambala mu Excel

Nthaŵi zina, manambala amalembedwa kapena kutumizidwa ku spreadsheet amasinthidwa kukhala deta. Izi zingachititse mavuto ngati deta ikugwiritsidwa ntchito ngati kutsutsana kwa mapulojekiti ena omangidwa monga ntchito kapena SUMBA .

Zosankha zothetsera vutoli zikuphatikizapo:

Zosankha 1: Sakani Zapadera mu Excel

Kugwiritsira ntchito padera wapadera kutembenuza deta pamasamba ndi kosavuta komanso monga mwayi umene deta yosinthika imakhalabe pamalo ake oyambirira - mosiyana ndi ntchito VALUE yomwe imafuna kuti deta ilibenso kukhala malo osiyana kuchokera ku deta yoyambirira.

Zosankha 2: Gwiritsani Bulu Lotsutsa mu Excel

Monga momwe tawonetsera pa chithunzi pamwambapa, Chophika Cholakwika kapena Chotsutsana Chotsutsana Chotsalira mu Excel ndi kachilombo kakang'ono kam'kasu kamene kakuwoneka pafupi ndi maselo omwe ali ndi zolakwika za deta - monga pamene chiwerengero cha chiwerengero chimawongolera ngati chigwiritsidwe ntchito mu fomu. Kuti mugwiritse ntchito Bukhu Lotsutsa kuti mutembenuzire deta yanu ku manambala:

1. Sankhani selo (s) zomwe zili ndi deta yolakwika
2. Dinani botani lolakwika pafupi ndi selo kuti mutsegule mndandanda wa zosankha
3. Dinani pa Sinthani ku Nambala mu menyu

Deta mu maselo osankhidwa ayenera kutembenuzidwa kukhala manambala.

Kulumikiza zida zolemba pa Excel ndi Google Spreadsheets

Mu Excel ndi Google Spreadsheets, khalidwe la ampersand (&) lingagwiritsidwe ntchito kugwirizanitsa palimodzi kapena kugwiritsira ntchito zingwe zolemba zomwe zili mu maselo osiyana m'malo atsopano. Mwachitsanzo, ngati ndime A ili ndi mayina oyambirira ndi ndime B maina otsiriza a anthu, maselo awiri a deta akhoza kuphatikizidwa palimodzi C.

Fomu yomwe idzachita izi ndi = (A1 & "" & B1).

Zindikirani: opersand opanga sapanga malo osakanikirana pakati pa zingwe zolembedwera kuti azitha kuwonjezeredwa pamanja. Izi zimachitika pozungulira chikhalidwe cha malo (adalowa pogwiritsa ntchito kamatabwa kamphindi pa kambokosi) ndi zizindikiro za quotation monga momwe zasonyezedwera mu ndondomeko pamwambapa.

Njira ina yothandizira masankhulidwe olembedwa ndi kugwiritsa ntchito CONCATENATE ntchito .

Kutaya Deta Zakale mu Maselo Ambiri okhala ndi Malemba ku Ma Columns

Kuchita zosiyana ndi kuvomereza - kupatulira selo limodzi la deta mu maselo awiri kapena awiri osiyana - Excel ali ndi Malemba a Ma Columns . Njira zothetsera ntchitoyi ndi izi:

1. Sankhani gawo la maselo omwe ali ndi deta yomwe ili pamodzi.
2. Dinani pa menyu ya Deta ya menyu.
3. Dinani pa Ndemanga kwa Mizati kuti mutsegule Text Converter ku Columns wizard.
4. Pansi pa mtundu woyambirira deta ya sitepe yoyamba, dinani Kuchulukitsa , ndiyeno dinani Kenako.
5. Pansi pa Gawo 2, sankhani chojambulidwa cholemba kapena choyimira pa data yanu, monga Tab kapena Space, ndiyeno dinani Zotsatira.
6. Pansi pa Gawo 3, sankhani mtundu woyenera pansi pa Dongosolo la deta , monga General.
7. Pansi pa Advanced batani chisankho, sankhani njira zina zosiyanitsira Chodzipatula ndi Zikwizikwi Zopatulira , ngati zolakwika - nthawi ndi comma motsatira - si zolondola.
8. Dinani Kutsirizitsa kuti mutseke wizara ndikubwerera ku tsamba la ntchito.
9. Mndandanda wa m'ndandanda yosankhidwayo tsopano ikhale yosiyana muzitsulo ziwiri kapena zina.