Hanyoyi 2 don Cire sarari Tsakanin Kalmomi ko Lambobi a cikin Kwayoyin Excel

A cikin wannan labarin, zaku koyi hanyoyi masu sauri guda 2 don cire ƙarin sarari tsakanin kalmomi ko duk sarari daga sel na Excel. Kuna iya amfani da aikin TASHIYA (TRIM) ko kayan aiki Nemo & Sauya (Nemo kuma Sauya) don tsaftace abubuwan da ke cikin sel a cikin Excel.

Lokacin da kuka liƙa bayanai daga tushen waje a cikin takardar Excel (rubutu bayyanannu, lambobi, da sauransu), kuna iya ƙarewa da ƙarin sarari tare da mahimman bayanai. Waɗannan na iya zama jagora da saƙon sarari, sarari da yawa tsakanin kalmomi, ko dubban masu rarraba cikin lambobi.

Sakamakon haka, tebur ɗin ya ɗan yi sanyi kuma ya zama da wahala a yi amfani da shi. Zai yi kama da aiki mai sauƙi zai iya zama da wahala. Misali, nemo mai siye mai suna John Doe (babu ƙarin sarari tsakanin sassan sunan), yayin da a cikin tebur an adana shi azaman "John Doe“. Ko lambobi waɗanda ba za a iya taƙaita su ba, kuma ƙarin sarari ne ke da laifi.

Daga wannan labarin za ku koyi yadda ake share bayanai daga ƙarin wurare:

• Muna cire duk ƙarin sarari tsakanin kalmomi, da kuma yanke jagora da sarari masu biyo baya
  • Yin amfani da aikin TRIM (TRIM).
  • Aiwatar da Nemo & Sauya kayan aikin (Nemo kuma Sauya)
• Cire DUK sarari tsakanin kalmomi ko lambobi

Cire duk ƙarin sarari tsakanin kalmomi, yanke jagora da sarari masu biyo baya

A ce muna da tebur mai ginshiƙai biyu. A cikin shafi sunan tantanin farko ya ƙunshi sunan John Doe, rubuta daidai, watau ba tare da ƙarin sarari ba. Duk sauran sel sun ƙunshi zaɓin shigarwa tare da ƙarin sarari tsakanin sunaye na farko da na ƙarshe, haka kuma a farkon da ƙarshen (jarraba da saƙo). A cikin shafi na biyu, tare da take Length, yana nuna adadin haruffa a kowane suna.

Yi amfani da aikin TRIM don cire ƙarin sarari

Akwai aiki a cikin Excel TASHIYA (TRIM), wanda ake amfani dashi don cire ƙarin sarari daga rubutu. A ƙasa zaku sami umarnin mataki-mataki don aiki tare da wannan kayan aikin:

1. Ƙara ginshiƙi mai taimako kusa da bayanan ku. Za a iya sunansa Gyara.
2. A cikin tantanin halitta na farko na ginshiƙin taimako (C2), shigar da dabara don cire ƙarin sarari:

   =TRIM(A2)

   =СЖПРОБЕЛЫ(A2)

   

3. Kwafi wannan dabara zuwa sauran sel a cikin ginshiƙi. Kuna iya amfani da shawarwarin daga labarin Yadda ake saka dabara iri ɗaya cikin duk sel da aka zaɓa lokaci ɗaya.
4. Maye gurbin asalin ginshiƙi tare da bayanan da aka karɓa. Don yin wannan, zaɓi duk sel na ginshiƙin taimako kuma danna Ctrl + Cdon kwafe bayanan zuwa allo. Na gaba, zaɓi tantanin halitta na farko na ginshiƙi na asali (a cikin yanayin mu A2), danna Canji + F10 ko maɓallin menu na gajeriyar hanya, sannan maɓallin V (DA).
5. Share ginshiƙin taimako.

Shirya! Mun cire duk ƙarin sarari tare da aikin TASHIYA (TRIM SPACES). Abin takaici, wannan hanyar tana ɗaukar lokaci mai yawa, musamman ma lokacin da tebur ya yi girma sosai.

lura: Idan har yanzu kuna ganin ƙarin sarari bayan amfani da dabarar, wataƙila rubutun yana ƙunshe da wuraren da ba sa karyewa. Yadda za a cire su, za ku iya koya daga wannan misalin.

Yi amfani da Nemo da Sauya kayan aiki don cire ƙarin sarari tsakanin kalmomi

Wannan zaɓi yana buƙatar ƙarancin aiki, amma yana ba ku damar cire ƙarin sarari tsakanin kalmomi kawai. Hakanan za a datsa wuraren jagora da masu bin diddigi zuwa 1, amma ba za a cire gaba ɗaya ba.

1. Zaɓi ɗaya ko fiye ginshiƙan bayanai waɗanda a ciki kuke son cire ƙarin sarari tsakanin kalmomi.
2. latsa Ctrl + Hdon buɗe akwatin maganganu Nemo & Sauya (Nemo ku maye gurbin).
3. Shigar da sarari sau biyu a cikin filin Nemo Abin da (Nemi) kuma sau ɗaya a cikin filin Sauya da (Maye gurbinsa).
4. latsa Sauya duka (Maye gurbin Duka) sannan OKdon rufe taga bayanin da ya bayyana.
5. Maimaita mataki na 4 har sai sakon ya bayyana Ba mu sami abin da za mu maye gurbin ba… (Ba mu sami wani abu da ake buƙatar maye gurbin ba…).

Cire duk sarari tsakanin lambobi

A ce kana da tebur mai lambobi wanda rukunin lambobi (dubbai, miliyoyi, biliyoyin) ke raba su ta sarari. A wannan yanayin, Excel yana ɗaukar lambobi azaman rubutu kuma ba za a iya yin aikin lissafi ba.

Hanya mafi sauƙi don kawar da ƙarin sarari shine amfani da daidaitaccen kayan aikin Excel - Nemo & Sauya (Nemo ku maye gurbin).

• latsa Ctrl+Space (Space) don zaɓar duk sel a cikin ginshiƙi.
• latsa Ctrl + Hdon buɗe maganganun Nemo & Sauya (Nemo ku maye gurbin).
• a cikin Nemo Abin da (Nemo) shigar da sarari ɗaya. Tabbatar filin Sauya da (Maye gurbin da) - komai.
• latsa Sauya duka (Maye gurbin Duka), sannan OK. Voila! An cire duk sarari.

Cire duk sarari ta amfani da dabara

Kuna iya samun amfani don amfani da dabara don cire duk sarari. Don yin wannan, zaku iya ƙirƙirar ginshiƙi na taimako kuma shigar da dabara mai zuwa:

=SUBSTITUTE(A1," ","")

=ПОДСТАВИТЬ(A1;" ";"")

nan A1 ita ce tantanin halitta na farko a cikin ginshiƙi mai ɗauke da lambobi ko kalmomi, wanda dole ne a cire duk sarari.

Na gaba, bi matakai iri ɗaya kamar a cikin sashin cire duk ƙarin sarari tsakanin kalmomi ta amfani da dabara.