Ƙinƙidar Maɗaure ko Rubutun Magana a cikin Excel

Harshen rubutu, wanda aka sani da kirtani ko kuma kamar yadda rubutun ƙungiya ne na haruffan da aka yi amfani dashi azaman bayanai a cikin shirin shafukan.

Kodayake kalmomin rubutu sun fi sau da yawa sun hada da kalmomi, suna iya hada da waɗannan haruffa kamar haka:

Ta hanyar tsoho, ƙirar rubutu an bar haɗin kai a cikin tantanin halitta yayin da adadin lambobi suna haɗa kai tsaye.

Bayanin tsara bayanai kamar rubutu

Kodayake kalmomin rubutu sukan fara da harafin haruffa, duk wani shigarwar bayanai wanda aka tsara kamar yadda aka fassara rubutu a matsayin kirtani.

Ana canza Lissafi da Formulas zuwa Rubutu tare da Apostrophe

Za a iya kirkirar maƙalli rubutu a cikin Excel da kuma Shafukan Lissafi ta Google ta shigar da apostrophe ( ' ) a matsayin halin farko na bayanan.

Babu kuskure a cikin tantanin halitta sai dai ya tilasta shirin ya fassara duk lambobi ko alamomin da aka shigar bayan apostrophe a matsayin rubutu.

Alal misali, don shigar da wata ma'anar kamar = A1 + B2 a matsayin rubutu na rubutu, rubuta:

'= A1 + B2

Mutumin, wanda ba a bayyane ba, yana hana shirin tattara bayanai daga fassarar shigarwa a matsayin tsari.

Karɓar Harshen Rubutun Hoto zuwa Lambar Bayanai a Excel

A wasu lokuta, lambobin da aka kwafe ko a shigo da su a cikin ɗakunan rubutu suna canzawa zuwa bayanan rubutu. Wannan zai iya haifar da matsala idan an yi amfani da bayanan a matsayin hujja ga wasu daga cikin shirye-shiryen 'ayyukan ginawa kamar SUM ko AVERAGE .

Zaɓuɓɓuka don gyara wannan matsala sun haɗa da:

Zabin 1: Manna Musamman a Excel

Yin amfani da ƙwaƙwalwar musamman don sauya bayanan rubutu zuwa lambobi yana da sauƙi mai sauƙi kuma a matsayin amfani da cewa bayanai masu juyayi sun kasance a wurin asalinsa - ba kamar aikin da yake da shi ba wanda ya buƙatar bayanan da aka tattara don zama a wuri dabam daga bayanan rubutu na ainihi.

Hanya na 2: Yi amfani da Button Error a Excel

Kamar yadda aka nuna a cikin hoton da ke sama, maɓallin Kuskuren ko kuskuren Kuskuren a Excel shine karamin rawaya na launin rawaya wadda ta bayyana kusa da kwayoyin da ke dauke da kurakuran bayanai - irin su lokacin da aka tsara adadin lambobin da aka yi amfani da shi azaman rubutu a cikin wata hanya. Don amfani da Maɓallin Kuskure don sauya bayanan rubutu zuwa lambobi:

  1. Zaɓi tantanin halitta (s) wanda ke dauke da bayanai mara kyau
  2. Danna maɓallin kuskure kusa da tantanin halitta don buɗe mahallin menu na zabin
  3. Danna kan Sauyawa zuwa Lambar a menu

Dole ne a canza bayanan da aka sanya a cikin sassan da aka zaba zuwa lambobi.

Cikakken rubutun kalmomi a cikin Excel da Shafukan rubutun Google

A cikin Excel da Shafukan Gizon Google, ana iya amfani da ampersand (&) hali don shiga tare ko don ƙaddara kalmomin da ke cikin sel daban a sabon wuri. Alal misali, idan shafi na A ya ƙunshi sunayen farko da shafi na B sunaye na karshe na mutane, za'a iya haɗa nau'o'in bayanai guda biyu a shafi na C.

Ma'anar da za ta yi wannan shine = (A1 & "" & B1).

Lura: mai tafiyar da ayyukan ampersand ba ta sanya tazarar ta atomatik tsakanin igiyoyin rubutu ba, don haka dole ne a kara su tare da wannan dabara. Anyi wannan ta hanyar kewaye da halayen sararin samaniya (ya shiga ta amfani da filin sarari a kan keyboard) tare da alamomi da aka nuna kamar yadda aka nuna a cikin tsari a sama.

Wani zaɓi don shiga rubutun rubutu shine don amfani da aikin CONCATENATE .

Rubutattun Bayanin Rubutun Bayanai zuwa Multiple Cells tare da Rubutu zuwa ginshiƙai

Don yin kishiyar ƙaddamarwa - don raba tantanin tantanin halitta guda biyu a cikin guda biyu ko fiye daban-daban - Excel yana da rubutun zuwa Rubutun . Matakan da za a cim ma wannan aikin shine:

  1. Zaɓi shafi na sel dauke da bayanan rubutu tare.
  2. Danna kan Yanayin Bayanan menu na ribbon menu.
  3. Danna Rubutu zuwa ginshiƙai don buɗe Rubutun Maɓallin zuwa Maɓallin ginshiƙan .
  4. A ƙarƙashin samfurin asali na farko, danna Delimited , sa'an nan kuma danna Next.
  5. A karkashin Mataki na 2, zaɓi madaidaicin rubutun kalmomi ko mai kulawa don bayananka, kamar Tab ko Space, sannan ka danna Next.
  6. A karkashin Mataki na 3, zaɓi tsari mai dacewa a ƙarƙashin tsarin Bayanin shafi , kamar Janar.
  7. A ƙarƙashin zaɓi na Ƙararrawa, zabi saituna madaidaiciya don mai rabawa na Decimal da Dubban masu rabawa , idan ɓangarori na ɓangaren lokaci - lokaci da lambobi daidai - ba daidai bane.
  8. Danna Ƙarshe don rufe masanin kuma komawa zuwa aikin aiki.
  9. Ya kamata a rabu da rubutun a cikin jerin da aka zaba a cikin ginshiƙai biyu ko fiye.