Yadda ake cire apostrophe a cikin Excel

Ɗaya daga cikin alamomin rubutu na madannai shine ridda, kuma a cikin maƙunsar rubutu na Excel yawanci yana nufin tsarin rubutu na lambobi. Wannan alamar sau da yawa tana bayyana a wuraren da ba su dace ba, wannan matsalar kuma tana faruwa da wasu haruffa ko haruffa. Bari mu gano yadda za a share tebur na tsoma baki haruffa marasa amfani.

Yadda ake cire apostrophe a bayyane a cikin tantanin halitta

Rubuce-rubucen ƙayyadaddun alamar rubutu ne, an rubuta shi kawai a cikin takamaiman lokuta. Misali, yana iya fitowa a cikin sunaye masu kyau ko a ƙididdige ƙididdiga. Duk da haka, wani lokacin masu amfani da Excel suna rubuta bayanan baya a wuraren da ba daidai ba. Idan akwai ƙarin haruffa da yawa a cikin tebur, zaku iya maye gurbin su da wasu. Bari mu gano yadda za a yi shi a cikin ƴan matakai masu sauri ta amfani da kayan aikin shirin.

1. Zaɓi sel inda haruffan da ba daidai ba suke. A kan shafin "Gida", nemo maɓallin "Nemi kuma zaɓi" kuma danna kan shi.

2. Zaɓi abu "Maye gurbin" a cikin menu wanda ya buɗe ko danna maɓallan zafi "Ctrl + H".

3. Akwatin maganganu zai buɗe tare da filaye biyu. A cikin layin da ke ƙarƙashin taken "Nemo" kuna buƙatar shigar da alamar da aka rubuta ba daidai ba - a cikin wannan yanayin, ridda. Mun rubuta a cikin layin "Maye gurbin da" sabon hali. Idan kawai kuna son cire ridda, bar layi na biyu babu komai. Misali, bari mu musanya waƙafi a cikin ginshiƙin “Maye gurbin da” kuma danna maɓallin “Maye gurbin Duka”.

4. Yanzu a cikin tebur maimakon apostrophes akwai waƙafi.

Kuna iya maye gurbin apostrophes ba kawai a kan takarda ɗaya ba, amma a cikin littafin. Danna maɓallin "Zaɓuɓɓuka" a cikin akwatin tattaunawa na maye gurbin - sababbin zaɓuɓɓuka za su bayyana. Don saka haruffa ɗaya maimakon wani akan duk takaddun takaddun, zaɓi zaɓin "A cikin littafin" a cikin abin "Bincike" kuma danna "Maye gurbin Duk".

Yadda ake cire ridda marar ganuwa kafin kirtani

Wani lokaci idan ana kwafin dabi'u daga wasu shirye-shirye, ɓatanci yana bayyana a gaban lamba a mashigin dabara. Wannan halin ba ya cikin tantanin halitta. Apostrophe yana nuna tsarin rubutu na abubuwan da ke cikin tantanin halitta - an tsara lambar azaman rubutu, kuma wannan yana tsoma baki tare da lissafin. Irin waɗannan haruffa ba za a iya cire su ta hanyar canza tsari, kayan aiki Excel ko ayyuka. Dole ne ku yi amfani da Editan Kayayyakin Kaya.

1. Buɗe Kayayyakin Basic don Aikace-aikace taga ta amfani da haɗin maɓallin Alt+F
2. Ana samun editan a cikin Turanci kawai. Mun sami a saman mashaya menu Saka (Saka) kuma danna abu Module (Module).

3. Rubuta macro don cire ridda.

Hankali! Idan ba zai yiwu ka ƙirƙiri macro da kanka ba, yi amfani da wannan rubutun.

4. Zaɓi kewayon sel inda ƙarin harafin ya bayyana, kuma danna haɗin maɓallin "Alt + F8". Bayan haka, ayoyin za su ɓace kuma lambobin za su ɗauki tsari daidai.

Cire ƙarin sarari daga tebur

Ana sanya ƙarin sarari a cikin tebur na Excel don raba manyan lambobi zuwa sassa ko kuskure. Idan kun san cewa akwai wurare da yawa a cikin takaddar waɗanda bai kamata su kasance ba, yi amfani da Wizard Aiki.

1. Zaɓi tantanin halitta kyauta kuma buɗe taga Mai sarrafa Aiki. Za a iya samun damar lissafin tsarin ta hanyar danna alamar "F(x)" kusa da ma'aunin dabara ko ta shafin "Formulas" a kan kayan aiki.

2. Bude nau'in "Text", an jera shi a cikin akwatin maganganu ko a shafin "Formulas" azaman sashe daban. Dole ne ku zaɓi aikin TRIM. Hoton yana nuna hanyoyi biyu.

3. Tantanin halitta ɗaya ne kawai zai iya zama hujjar aiki. Mun danna tantanin halitta da ake so, sunan sa zai fada cikin layin muhawara. Na gaba, danna "Ok".

4. Muna cika layi da yawa, idan ya cancanta. Danna saman tantanin halitta inda dabarar take kuma ka riƙe ƙasa da alamar murabba'in baƙar fata a cikin ƙananan kusurwar dama. Zaɓi duk sel inda kake son ƙima ko rubutu ba tare da sarari ba kuma saki maɓallin linzamin kwamfuta.

Muhimmin! Ba shi yiwuwa a share dukan takardar na ƙarin sarari, dole ne ku yi amfani da dabarar a cikin ginshiƙai daban-daban kowane lokaci. Aikin yana ɗaukar ɗan lokaci kaɗan, don haka ba za a sami matsaloli ba.

Yadda ake cire haruffa na musamman marasa ganuwa

Idan harafi na musamman a cikin shirin ba zai iya karantawa ba, dole ne a cire shi. Ayyukan TRIM ba ya aiki a irin waɗannan lokuta, saboda irin wannan sarari tsakanin haruffa ba sarari bane, kodayake suna kama da juna. Akwai hanyoyi guda biyu don share daftarin aiki daga haruffa marasa karantawa. Hanya ta farko don cire haruffan Excel waɗanda ba a sani ba shine amfani da zaɓin "Maye gurbin".

1. Bude taga sauyawa ta maɓallin "Nemi kuma zaɓi" akan babban shafin. Wani madadin kayan aiki da ke buɗe wannan akwatin maganganu shine gajeriyar hanyar maɓalli "Ctrl+H".
2. Kwafi haruffan da ba za a iya karantawa ba (wurin da babu kowa a ciki) sannan a liƙa su cikin layin farko. An bar filin na biyu babu kowa.
3. Danna maɓallin "Maye gurbin Duk" - haruffan za su ɓace daga takardar ko daga dukan littafin. Kuna iya daidaita kewayon a cikin "Parameters", an tattauna wannan matakin a baya.

A hanya ta biyu, muna sake amfani da fasalulluka na Mayen Aiki. Misali, bari mu saka shigarwa tare da karya layi cikin ɗayan sel.

1. Rukunin "Text" ya ƙunshi aikin PRINT, yana amsa duk wani haruffa marasa bugawa. Kuna buƙatar zaɓar shi daga lissafin.

2. Mun cika filin kawai a cikin akwatin maganganu - yakamata a bayyana sunan tantanin halitta inda akwai ƙarin hali. Danna maɓallin "Ok".

Ba za a iya cire wasu haruffa ta amfani da aikin ba, a irin waɗannan yanayi yana da kyau a juya zuwa sauyawa.

• Idan kana buƙatar sanya wani abu dabam maimakon haruffan da ba za a iya karantawa ba, yi amfani da aikin SUBSTITUTE. Wannan hanya kuma tana da amfani a lokuta da aka yi kuskure a cikin kalmomin. Aikin yana cikin nau'in "Text".
• Domin dabarar ta yi aiki daidai, kuna buƙatar cika hujjoji guda uku. Filin farko ya ƙunshi tantanin halitta mai rubutu wanda ake maye gurbin haruffa. An tanada layi na biyu don halin maye gurbin, a cikin layi na uku muna rubuta sabon harafi ko harafi. Yawancin kalmomi suna maimaita haruffa, don haka jayayya uku ba su isa ba.

• Lambar abin da ya faru lamba ce da ke nuna wane hali na wasu iri ɗaya ya kamata a maye gurbinsu. Misalin ya nuna cewa an maye gurbin harafin “a” na biyu, ko da yake yana cikin kalmar daidai. Bari mu rubuta lamba 1 a cikin filin "Lambar faruwa", kuma sakamakon zai canza. Yanzu zaku iya danna Ok.

Kammalawa

Labarin yayi la'akari da duk hanyoyin da za a cire ridda. Bin umarni masu sauƙi, kowane mai amfani zai iya jimre wa aikin ba tare da wata matsala ba.