Adadi a cikin kalmomi a cikin Excel. Yadda ake rubuta adadin a cikin kalmomi a cikin Excel

An fi amfani da kayan aikin Microsoft Excel don aiki da lambobi. Wani lokaci yakan zama dole a rubuta lamba, kamar jimlar kuɗi, da kalmomi. Wannan ya zama mahimmanci musamman lokacin zana takardun kuɗi. Rubuta kowace lamba a cikin kalmomi da hannu ba shi da daɗi. Bugu da ƙari, lambobi a cikin suna ɗaya daga cikin batutuwa masu wahala, kuma ba kowa ba ne ya san ka'idojin rubuta su. Jahilci a cikin takardu yana cutar da sunan kamfani, don haka ya kamata ku yi amfani da taimakon ayyukan Excel. Bari mu gano yadda ake ƙara aikin “Ƙididdiga cikin kalmomi” a cikin shirin kuma mu yi amfani da shi daidai.

Kunna ƙara NUM2TEXT a cikin menu na Excel

Kafin ƙirƙirar sel tare da jimla a cikin kalmomi, kuna buƙatar zazzage ƙari don Microsoft Excel. Babu add-ons akan gidan yanar gizon masu haɓakawa, amma ana iya sauke shi daga wasu shafuka. Yana da mahimmanci a duba fayilolin da aka sauke zuwa kwamfutar ta amfani da shirin riga-kafi, in ba haka ba akwai haɗarin kamuwa da tsarin tare da kwayar cuta. Hakanan kula da izinin fayil ɗin. Madaidaicin ƙuduri shine XLA. Idan an riga an zazzage add-in, sanya shi cikin babban fayil inda zai sami sauƙin samu. Wannan zai zo da amfani lokacin haɗawa. Na gaba, za mu yi nazarin haɗa abubuwan ƙarawa mataki-mataki:

1. Kuna buƙatar buɗe shafin "Fayil" a cikin takaddar Excel kuma zaɓi sashin "Zaɓuɓɓuka". Yawancin lokaci ana samunsa a kasan jerin sashe.

2. Zaɓuɓɓukan taga za su buɗe tare da menu a gefen hagu. Zaɓi sashin "Add-ons". Idan ka duba gefen dama na allon, za ka ga cewa wasu daga cikinsu an riga an shigar da su, amma ba su dace da sauƙaƙan rubuta adadin a cikin kalmomi ba.

A ƙasa akwai sashin "Management" tare da maɓallin "Tafi". Mun danna wannan maɓallin.

3. Taga tare da samuwan add-ons zai bayyana akan allon. Kuna iya kunna wasu daga cikinsu idan an buƙata, amma makasudin a wannan yanayin shine maɓallin Bincike.

4. Muna samun fayil ɗin tare da ƙara ta cikin taga mai bincike. Danna shi don zaɓar shi kuma danna Ok.

5. Abun "Num2Text" zai bayyana a cikin jerin add-ons. Ya kamata a sami alamar bincike kusa da shi. Idan ba a cikin taga ba, kuna buƙatar zaɓar wannan add-in da hannu kuma danna "Ok".

An gama haɗin haɗin "Ƙididdiga a cikin kalmomi" add-on, yanzu za ku iya amfani da shi.

Ayyuka tare da ƙarawa bayan haɗi

Add-on "Yawan a cikin kalmomi" kari ne ga "Mai sarrafa Aiki" Excel. Ta ƙara sabuwar dabara guda ɗaya a lissafin, wanda da ita zaku iya juya kowace lamba zuwa kalmomi. Bari mu tuna yadda ake aiki tare da “Feature Manager” kuma mu kalli abin ƙarawa a aikace.

1. Bari mu yi tebur mai lambobi waɗanda ke buƙatar rubuta su cikin kalmomi. Idan akwai akwai, kawai kuna buƙatar buɗe takaddar inda aka haɗa ta.
2. Na gaba, danna kan fanko tantanin halitta inda adadin ya kamata ya bayyana a cikin kalmomi, kuma buɗe "Mai sarrafa Ayyuka".

Muhimmin! Kuna iya zuwa wannan sashe na Excel ta hanyoyi da yawa: ta gunkin da ke kusa da layin aiki ko ta hanyar Formulas tab (maɓallin Saka Aiki).

3. Zaɓi nau'in "Cikakken lissafin haruffa". Dole ne ku gungura ƙasa zuwa harafin “C” saboda fasalin bai dace da kowane ƙunƙun rukunan ba. Na gaba, kuna buƙatar danna sunan aikin "Ƙididdigan kalmomi" kuma danna "Ok".

4. Zaɓi tantanin halitta mai lamba wanda ƙimar rubutu yakamata ta bayyana a cikin tantanin halitta mara komai. Ya kamata zane mai raye-raye ya bayyana a kusa da shi, kuma zayyana a kwance da a tsaye za su fada cikin dabarar. Danna maɓallin "Ok".

5. A sakamakon haka, adadin da ke cikin kalmomi yana bayyana a cikin tantanin halitta da aka zaɓa a farkon. Ga alama kamar haka:

6. Yanzu zaku iya cika teburin duka ba tare da yin ayyuka iri ɗaya tare da kowane jere ba. Idan ka danna kowane tantanin halitta, baƙar fata za ta bayyana a kusa da shi (fari idan tantanin halitta yana cikin tebur mai iyakoki), kuma akwai alamar murabba'i mai baƙar fata a cikin ƙananan kusurwar dama. Zaɓi tantanin halitta inda aikin "Sum_in kalmomi" yake, riƙe ƙasa wannan murabba'in kuma ja shi zuwa ƙarshen tebur.

7. Tsarin zai matsa zuwa duk sel da ke ƙasa waɗanda zaɓin ya kama. Akwai motsi na sel, godiya ga wanda daidaitaccen adadin cikin kalmomi ya bayyana a kowane jere. Teburin yana ɗaukar tsari kamar haka:

Shigar da hannu na aiki a cikin sel

Maimakon shiga cikin matakai na bude "Function Manager" da neman aikin da ake so, za ka iya shigar da dabara kai tsaye a cikin tantanin halitta. Bari mu gano yadda ake cika tebur ba tare da amfani da kayan aiki ba.

1. Da farko kuna buƙatar zaɓar tantanin halitta mara komai inda za'a rubuta dabarar. Danna sau biyu akan shi - filin shigar da bayanai daga madannai zai bayyana a ciki.
2. Bari mu rubuta dabara mai zuwa a cikin filin da ba komai: = Adadin_cikin kalmomi().

Shawara! Bayan saita alamar daidai, shirin zai ba da alamu a cikin tsari. Ƙarin shigarwar kowane layi, mafi daidaitattun ambaton zai kasance. Zai fi dacewa don nemo aikin da ake so a cikin wannan jerin kuma danna sau biyu akansa.

3. A cikin baka, kuna buƙatar ƙayyade tantanin halitta, abin da ke ciki za a rubuta cikin kalmomi.

Kula! Yana yiwuwa a rubuta cikin kalmomi ba kawai abubuwan da ke cikin lambobi na tantanin halitta ɗaya ba, har ma da sakamakon aikin lissafi tare da lambobi daga sel da yawa. Misali, idan ka zabi tantanin halitta daya, sai ka sanya alamar “+” bayan zayyana ta sannan ka nuna kalma ta biyu – wata tantanin halitta, to sakamakon zai zama jimillar lambobi biyu da aka rubuta cikin kalmomi.

4. Danna maɓallin "Shigar". Kwayoyin za su nuna lamba ko sakamakon wani aiki, wanda aka bayyana cikin kalmomi.

Yana yiwuwa a rubuta lamba a cikin kalmomi ba tare da ƙirƙirar tebur ba - duk abin da kuke buƙata shine tsari da iri ko aiki. Hakanan wajibi ne a rubuta dabara a cikin tantanin halitta mara komai, amma a cikin maƙallan, maimakon alamomin kwance da na tsaye, rubuta lamba ko magana. Rufe maƙallan kuma danna "Shigar" - lambobi masu mahimmanci suna bayyana a cikin tantanin halitta.

Kammalawa

Don rubuta lambobi a cikin kalmomi, kuna buƙatar zazzage ƙari don Microsoft Excel kuma haɗa shi zuwa shirin kuma kunna shi, "Mai sarrafa ayyuka" yana taka muhimmiyar rawa a cikin ƙarin ayyuka. Ana iya amfani da aikin duka zuwa abubuwan da ke cikin sel da lambobi a wajen tebur. Ta hanyar sanya furci na lissafi a cikin aiki, zaku iya samun sakamakonsa a cikin furci.