Canza harafin farko daga caseara zuwa babban babba a Microsoft Excel

A yawancin lokuta, ana buƙatar harafin farko a cikin tebur na tebur don zama babban. Idan mai amfani da farko ya yi kuskuren shigar da ƙananan ƙananan haruffa ko'ina ko aka kwafa cikin bayanan Excel daga wata hanyar da duk kalmomin suka fara da ƙaramin harafi, to ana iya yin amfani da lokaci da ɗimbin yawa don kawo bayyanar tebur zuwa yanayin da ake so. Amma wataƙila Excel tana da kayan aikin musamman waɗanda za su iya sarrafa wannan hanyar? Lallai, shirin yana da aiki don canza casearamin baki zuwa babban Bari mu kalli yadda yake aiki.

Hanya don sauya harafin farko zuwa babban mutum

Kada kuyi tsammanin cewa Excel tana da maɓallin keɓancewa, ta danna kan wanda zaku iya juya karamin letteraramin harafi ta atomatik cikin babban wasiƙa. Don yin wannan, dole ne kuyi amfani da ayyuka, kuma da yawa lokaci daya. Koyaya, a kowane hali, wannan hanyar zata wuce biyan farashi na lokacin da za'a buƙaci canza da bayanai.

Hanyar 1: maye gurbin harafin farko a cikin sel tare da babban harafi

Don magance matsalar, ana amfani da babban aikin. SANARWA, kazalika da ayyukan zamantakewa na farkon da na biyu KYAUTA da LEVSIMV.

• Aiki SANARWA maye gurbin halayya ɗaya ko ɓangaren kirtani tare da wasu, gwargwadon ƙayyadaddun muhawara;
• KYAUTA - yana sanya haruffa babban harafi, shine, manyan haruffa, wanda shine abin da muke buƙata;
• LEVSIMV - yana dawo da takamaiman adadin haruffan wani takamaiman rubutu a cikin sel.

Wato, dangane da wannan tsarin ayyuka, ta amfani LEVSIMV za mu dawo da wasiƙar farko ga ƙayyadaddun tantanin halitta ta amfani da afareta KYAUTA sanya shi babban birnin sannan kuma aiki SANARWA maye gurbin casearamin baki tare da babban

Babban samfurin wannan aikin zai yi kama da wannan:

= KARANTA (tsohuwar_text; farkon_pos; yawan haruffa; CAPITAL (LEVSIMV (rubutu; adadin haruffa))))

Amma yana da kyau a yi la’akari da duk wannan tare da misalin tabbatacce. Don haka, muna da cikakken tebur wanda aka rubuta kalmomi tare da ƙaramin harafi. Dole ne mu sanya halin farko a cikin kowane tantanin halitta tare da surnames capitalized. Kwayar farko tare da suna na karshe suna da masu gudanarwa B4.

1. A kowace sarari kyauta na wannan takarda ko a kan wata takarda, rubuta dabarar da ke tafe:

   = KARANTA (B4; 1; 1; KYAUTA (LEVISIM (B4; 1)))



2. Don aiwatar da bayanan da ganin sakamakon, latsa maɓallin Shigar da ke kan maballin. Kamar yadda kake gani, yanzu a cikin sel kalmar farko tana farawa da babban harafi.



3. Mun zama siginan kwamfuta a cikin ƙananan hagu na sel tare da dabara kuma muna amfani da alamar cikawa don kwafa dabarar zuwa ƙananan ƙwayoyin. Dole ne mu kwafa shi daidai matsayin da yawa kamar yadda adadin ƙwayoyin da sunayen ƙarshe suke da su a cikin ainihin teburin.



4. Kamar yadda kake gani, ganin cewa hanyoyin da ke cikin tsarin suna da alaƙa, kuma ba cikakke bane, kwafa ta faru tare da juyawa. Sabili da haka, a cikin ƙananan ƙwayoyin an nuna abun ciki na waɗannan wurare masu zuwa, amma kuma tare da babban wasiƙa. Yanzu muna buƙatar saka sakamakon a cikin teburin tushen. Zaɓi iyaka tare da dabaru. Mun danna-dama kuma zaɓi abu a cikin mahallin menu Kwafa.



5. Bayan haka, zaɓi ƙwayoyin asalin tare da sunayen ƙarshe a cikin tebur. Muna kiran menu na mahallin ta danna maɓallin linzamin kwamfuta na dama. A toshe Saka Zabi zaɓi abu "Dabi'u", wanda aka gabatar azaman gunki tare da lambobi.



6. Kamar yadda kake gani, bayan wannan an saka bayanan da muke buƙata a cikin matsayin asali na teburin. A lokaci guda, ƙananan haruffa a farkon kalmomin sel an maye gurbinsu da babban. Yanzu, don kada ku lalata bayyanar takardar, kuna buƙatar share sel tare da dabaru. Yana da mahimmanci musamman don aiwatar da cirewar idan kun yi jujjuyawar a kan takardar guda. Zaɓi kewayon da aka ƙayyade, danna-dama kuma a menu na mahallin, dakatar da zaɓi akan abu "Share ...".



7. A cikin karamar akwatin tattaunawa da ke bayyana, saita canza zuwa "Layi". Latsa maballin "Ok".

Bayan haka, za a share ƙarin bayanan, kuma za mu sami sakamakon da muka cim ma: a cikin kowace ƙwayar tebur, kalmar farko tana farawa da babban harafi.

Hanyar 2: yi amfani da kowace kalma

Amma akwai wasu lokuta waɗanda kuna buƙatar yin ba kawai kalmar farko ba a cikin tantanin halitta, farawa da babban harafi, amma gabaɗaya, kowace kalma. Hakanan akwai aikin daban don wannan, haka ma, yana da sauƙin sauƙaƙa fiye da wacce ta gabata. Ana kiran wannan aikin ADDU'A. Syntax mai sauqi qwarai ce:

= KYAUTATA (cell_address)

A cikin misalinmu, aikace-aikacen sa zai yi kama da haka.

1. Zaɓi yankin kyauta. Danna alamar "Saka aikin".



2. A cikin Wutar Aiki na bude, nemi ADDU'A. Bayan samo sunan nan, zaɓi shi kuma danna maɓallin "Ok".



3. Tattaunawa ta buɗe tana buɗewa. Sanya siginan kwamfuta a cikin filin "Rubutu". Zaɓi sel na farko tare da sunan ƙarshe a cikin teburin tushen. Bayan adireshinta yana cikin filin na muhawara, danna maballin "Ok".

   

   Akwai wani zabin ba tare da fara Mayen aikin ba. Don yin wannan, dole ne, kamar yadda a cikin hanyar da ta gabata, shigar da aikin a cikin tantanin halitta tare da yin rikodin daidaitawa na bayanan tushen. A wannan yanayin, wannan shigarwar zata yi kama da haka:

   = SARKI (B4)

   Sannan zaku buƙaci danna maɓallin Shigar.

   Zaɓin zaɓin takamaiman zaɓi ya rage ga mai amfani. Ga waɗancan masu amfani waɗanda ba a amfani da su don ɗaukar dabaru daban-daban a cikin kawunansu, yana da sauƙi sauƙi don aiki tare da taimakon Mayen Aiki. A lokaci guda, wasu sun yi imani cewa shigarwar mai amfani da kayan aiki yana da sauri sosai.

4. Kowane zaɓi aka zaɓi, a cikin tantanin tare da aikin da muka samu sakamakon da muke buƙata. Yanzu kowace sabuwar kalma a cikin tantanin halitta tana farawa da babban harafi. Kamar lokacin ƙarshe, kwafa dabarar ga sel ɗin da ke ƙasa.



5. Bayan wannan, kwafa sakamakon ta amfani da menu na mahallin.



6. Saka bayanai ta hanyar kayan "Dabi'u" saka zaɓuɓɓuka a cikin teburin tushen.



7. Share ƙa'idodin matsakaici ta cikin menu na mahallin.



8. A cikin sabon taga, tabbatar da share layin ta saita sauyawa zuwa inda ya dace. Latsa maɓallin "Ok".

Bayan haka, zamu sami jigon tushen abin da ba a canzawa ba, amma duk kalmomin da ke cikin sel ɗin da aka sarrafa yanzu za a rubuta su tare da babban harafi.

Kamar yadda kake gani, duk da cewa yawan jujjuyawar babban toara zuwa manyan haruffa a cikin Excel ta hanyar dabara na musamman ba za a iya kira shi da matakin farko ba, duk da haka, ya fi sauƙi kuma ya fi dacewa fiye da canza haruffa da hannu, musamman idan akwai su da yawa. Algorithms da ke sama suna adana ba kawai ƙarfin mai amfani ba, har ma da mafi mahimmanci - lokaci. Sabili da haka, yana da kyawawa cewa mai amfani da kullun na Excel zai iya amfani da waɗannan kayan aikin a cikin aikin su.