A yawancin lokuta, ana buƙatar cewa wasikar farko a cikin tantanin tantanin tantanin halitta. Idan mai amfani ya kuskuren ya shiga haruffan ƙananan haruffa a ko'ina ko kofe bayanai daga wani tushe zuwa Excel, inda duk kalmomi suka fara tare da ƙananan wasika, to, zaka iya ciyar da lokaci mai yawa da ƙoƙari don kawo bayyanar teburin zuwa jihar da kake so. Amma, watakila Excel na da kayan aiki na musamman da za ku iya sarrafa wannan hanya? Lalle ne, shirin yana da aiki na canza ƙananan haruffa zuwa babba. Bari mu dubi yadda yake aiki.
Hanyar canza matakan farko zuwa babban birnin
Kada ku yi tsammanin cewa Excel tana da maɓallin raba, ta danna kan wanda zaka iya juya wasikar ƙananan ta atomatik a cikin babban harafin. Don wannan, wajibi ne don amfani da ayyuka, da kuma sau da yawa. Duk da haka, a kowace harka, wannan hanyar zai wuce fiye da biyan kuɗin lokacin da farashin da ake buƙatar ya canza bayanai.
Hanyar 1: Sauya harafin farko a cikin salula tare da babban birnin
Don magance wannan matsala, ana amfani da babban aikin. Gyara, da ayyukan da aka haɓaka na farko da na biyu UPPER kuma LEFT.
- Yanayi Gyara ya maye gurbin hali ɗaya ko ɓangare na layi tare da wani, bisa ga ƙayyadaddun bayani;
- UPPER - sa haruffa manyan, wato, babba, wanda shine abin da muke bukata;
- LEFT - dawo da adadin takardun haruffa na takamaiman rubutu a cikin tantanin halitta.
Wato, dangane da wannan saitin ayyuka, ta amfani LEFT za mu mayar da wasikar farko zuwa cell da aka ƙayyade ta amfani da mai aiki UPPER sa shi babban birnin sa'an nan kuma aiki Gyara maye gurbin wasikar ƙananan tare da babban wasika.
Babban samfurin don wannan aiki zai zama kamar haka:
= Sauya (old_text; start_start; number_stars; PROPISN (LEFT (rubutu; number_stones)))
Amma yafi kyau a yi la'akari da wannan duka tare da misali mai mahimmanci. Don haka, muna da tebur mai cikawa wanda aka rubuta kalmomi tare da ƙananan wasika. Dole ne mu sanya hali na farko a cikin kowane tantanin halitta tare da sunayen karshe. Saiti na farko tare da suna na karshe yana da haɗin kai B4.
- A cikin kowane sarari na sarari na wannan takarda ko a wani takarda rubuta rubutu mai zuwa:
= REPLACE (B4; 1; 1; PROPISE (LEFT (B4; 1))) - Don aiwatar da bayanai da kuma ganin sakamakon, danna maɓallin shigarwa akan keyboard. Kamar yadda ka gani, yanzu a cikin tantanin halitta kalmar farko ta fara tare da babban harafin.
- Zamu zama siginan kwamfuta a cikin kusurwar hagu na tantanin halitta tare da tsari kuma ta amfani da alamar alamar ta kwafin takarda a cikin ƙananan ƙwayoyin. Dole ne mu kwafi shi daidai da matsayin da aka saukar, yawancin kwayoyin da sukaaye sunaye sun ƙunshi a cikin tebur na asali.
- Kamar yadda kake gani, an ba da cewa haɗin kai a cikin tsari shine dangi, kuma ba cikakke ba, kwafin ya faru tare da motsawa. Sabili da haka, ƙananan ƙwayoyin suna nuna abinda ke ciki na wurare masu biyowa, amma kuma tare da babban harafin. Yanzu muna buƙatar shigar da sakamakon zuwa cikin tebur na asali. Zaži kewayon da tsari. Danna maɓallin linzamin maɓallin dama kuma zaɓi abu a cikin mahallin menu "Kwafi".
- Bayan haka, zaɓar sunadaran Jirgin tare da sunaye na ƙarshe a teburin. Kira da mahallin mahallin ta danna maɓallin linzamin linzamin dama. A cikin toshe "Zaɓuɓɓukan Zaɓuka" zabi abu "Darajar"wanda aka gabatar a cikin hanyar gunki tare da lambobi.
- Kamar yadda ka gani, bayan wannan muna buƙatar an saka bayanai a cikin matsayi na asali na tebur. A wannan yanayin, haruffan ƙananan haruffa a kalmomin farko na sel an maye gurbinsu da babba. A yanzu, don kada kaya ganimar takardar, kana buƙatar cire sassan da kwayoyin. Yana da mahimmanci don sharewa idan kun yi fasalin a kan takarda. Zaɓi wurin da aka keɓance, dama-danna kuma dakatar da zaɓi a cikin mahallin menu. "Share ...".
- A cikin karamin akwatin maganganu wanda ya bayyana, saita maɓallin zuwa matsayin "Iri". Muna danna maɓallin "Ok".
Bayan haka, za a yalwata ƙarin bayanai, kuma za mu sami sakamakon da aka samu: a cikin kowane cell na tebur, kalmar farko ta fara da babban harafin.
Hanyar 2: Kowane kalma da babban harafin
Amma akwai lokuta idan ya zama dole don yin ba kawai kalma ta farko a cikin tantanin halitta ba, farawa da babban harafin, amma a maƙasudin, kowace kalma. Saboda wannan, akwai aikin dabam, kuma yana da sauki fiye da baya. Ana kiran wannan alamar PROPNACh. Hidimarta tana da sauqi:
= PROPNACH (adireshin salula)
A cikin misali, aikace-aikace zai kasance kamar haka.
- Zaɓi yanki kyauta na takardar. Danna kan gunkin "Saka aiki".
- A cikin aikin maye wanda ya buɗe, bincika PROPNACH. Gano wannan sunan, zaɓi shi kuma danna maballin. "Ok".
- Maganin gardama ya buɗe. Sa siginan kwamfuta a filin "Rubutu". Zaɓi sel ta farko tare da sunan karshe a cikin teburin tushe. Bayan da adireshinsa ya kai filin filin tattaunawa, za mu danna maballin "Ok".
Akwai wani zaɓi ba tare da fara Wizard na Gida ba. Don yin wannan, dole ne mu, kamar yadda muka riga muka yi, shigar da aiki a cikin salula da hannu tare da rikodin haɗin bayanan asali. A wannan yanayin, wannan shigarwa zai yi kama da wannan:
= PROPNAC (B4)Sa'an nan kuma kuna buƙatar danna maballin Shigar.
Zaɓin wani zaɓi na musamman ya dogara gaba ɗaya akan mai amfani. Ga masu amfani da ba su da masaniya don tunawa da yawancin matakai daban-daban, yana da sauki sauƙi don aiki tare da taimakon Maigidana Ayyuka. Bugu da ƙari, wasu sun gaskata cewa shigarwar mai aiki na manual ya fi sauri.
- Kowace zaɓin zaba, a cikin tantanin halitta tare da aikin mun sami sakamakon da muke bukata. Yanzu, kowace sabuwar kalma a cikin tantanin halitta zata fara tare da babban harafin. Kamar lokaci na ƙarshe, kwafe dabarar zuwa kwayoyin da ke ƙasa.
- Bayan haka, kwafa sakamakon ta amfani da menu mahallin.
- Mun saka bayanai ta hanyar abu "Darajar" saka zaɓuɓɓuka zuwa launi na tushen.
- Share matsakaicin matsakaici ta hanyar mahallin menu.
- A cikin sabon taga, muna tabbatar da sharewar layuka ta hanyar saita canji zuwa matsayin da ya dace. Muna danna maɓallin "Ok".
Bayan haka, za mu sami matakan layi wanda ba a canza ba, amma duk kalmomin da ke cikin kwayoyin sarrafawa za a iya rubuta su tare da babban harafin.
Kamar yadda kake gani, duk da gaskiyar cewa canjin canji na ƙananan haruffa zuwa babba a cikin Excel ta hanyar tsari na musamman ba za'a iya kira shi hanya na farko ba, yana da sauƙin kuma ya fi dacewa fiye da canja haruffa da hannu, musamman idan akwai mai yawa daga cikinsu. Wadannan algorithms na sama suna kare ba kawai ikon mai amfani ba, amma har ma lokaci mafi muhimmanci - lokaci. Saboda haka, yana da kyawawa cewa mai amfani na yau da kullum na Excel zai iya amfani da waɗannan kayan aiki a cikin aikin.
