Contents
Jiya a gudun marathon 30 Excel yana aiki a cikin kwanaki 30 mun yi karo da wani siriki malalaci mai suna AREAS (YANKI). Ba sau da yawa ana amfani da wannan aikin a aikace, amma tare da shi mun ga yadda ma'aikatan bincike guda uku ke aiki a cikin Excel. Da fatan wannan koyawa ta taimaka muku.
Za mu ba da rana ta uku na marathon don nazarin aikin TASHIYA (TRIM). A cikin Janairu, wani yana ƙoƙari ya rasa wasu ƙarin fam, kuma saboda wannan dalili za ku iya amfani da Excel don ƙirƙirar ƙididdigar calorie ko jadawali mai nauyi a ciki. Abin takaici aikin TASHIYA (TRIM) ba zai taimaka muku wajen yaƙi da ƙarin fam ba, amma yana iya cire ƙarin sarari daga layin rubutu.
Don haka bari mu kalli bayanan tunani da misalan amfani da aikin TASHIYA (TRIM) a cikin Excel. Idan kuna da naku dabaru ko misalai akan wannan aikin, da fatan za a raba su a cikin sharhi. Kuma sa'a mai kyau tare da kirga adadin kuzari!
Aiki 03: TRIM
aiki TASHIYA (TRIM) yana cire duk sarari daga igiyar rubutu banda sarari guda tsakanin kalmomi.
Ta yaya za ku yi amfani da aikin TRIM?
aiki TASHIYA (TRIM) na iya taimakawa wajen tsaftace rubutun da aka zazzage daga gidan yanar gizo ko aka shigo da shi daga wani aikace-aikacen. Aiki TASHIYA (TRIM):
- Yana kawar da sarari a farkon da ƙarshen layi.
- Yana kawar da duk sarari daga rubutu banda sarari ɗaya tsakanin kalmomi.
- Baya cire wasu harufa na musamman da aka kwafi daga gidan yanar gizon.
TRIM Syntax (TRIM)
Aikin TRIM yana da ma'ana mai zuwa:
TRIM(text)
СЖПРОБЕЛЫ(текст)
- text (rubutu) nuni ne zuwa sigar tantanin halitta ko rubutu wanda kake son cire sarari daga ciki
TARKUNAN TRIM
aiki TASHIYA (TRIM) kawai yana cire daidaitattun haruffan sarari daga rubutu. Idan kana kwafin rubutu daga gidan yanar gizo, yana iya ƙunsar haruffan sararin samaniya marasa karye, waɗanda ke aiki TASHIYA (TRIM) ba za a iya sharewa ba.
Misali 1: Cire sarari daga farkon da ƙarshen zaren rubutu
Kuna iya amfani da aikin TASHIYA (TRIM) don cire duk jagora da saƙon sarari daga layin rubutu. A cikin hoton da ke ƙasa, cell C5 ya ƙunshi rubutu tare da ƙarin wurare biyu a farkon da biyu a ƙarshen layi. Aiki TASHIYA (TRIM) a cikin tantanin halitta C7 yana cire waɗancan ƙarin wurare 4.
=TRIM(C5)
=СЖПРОБЕЛЫ(C5)
Misali 2: Cire duk sai dai sarari guda tsakanin kalmomi
Kuna iya amfani da aikin TASHIYA (TRIM) don ƙarin sarari tsakanin kalmomi a cikin rubutu. A cikin hoton da ke ƙasa, akwai ƙarin sarari guda uku tsakanin kalmomi a cikin cell C5. Aiki TASHIYA (TRIM) a cikin tantanin halitta C7 yana cire waɗancan wuraren, da ƙarin sarari biyu a farkon da ƙarshen saƙon rubutu.
=TRIM(C5)
=СЖПРОБЕЛЫ(C5)
Misali 3: Yadda KADA A cire wasu haruffa na musamman
aiki TASHIYA (TRIM) BA YA cire wasu haruffa da ake amfani da su azaman sarari. Misali, sarari mara karye yana yiwuwa ya kasance a cikin rubutun da aka kwafi daga gidan yanar gizo. A cikin hoton da ke ƙasa, cell C5 yana ƙunshe da sarari ɗaya mara karye, kuma ba a cire shi ba.
=TRIM(C5)
=СЖПРОБЕЛЫ(C5)
Kuna iya share alamar sarari mara karyewa da hannu ta amfani da aikin MUSA (MUSA) ko macro. Daga baya, a lokacin marathon mu 30 Excel yana aiki a cikin kwanaki 30Za ku koyi ƴan ƙarin hanyoyin don tsaftace bayanai a cikin Excel.
