Yadda za a yi harafin farko na babban birnin Amurka

A yawancin lokuta, ana buƙatar wasiƙar farko a cikin teburin tebur ya kasance (babban birnin). Idan mai amfani da farko ya shiga cikin ƙananan haruffa ko kwafin bayanai daga Excel, a cikin abin da kalmomin suka fara da karamin harafi, zaku iya ciyar da lokaci mai yawa da lokaci don kawo bayyanar tebur ga jihar da ake so. Amma, watakila, Fiff yana da kayan aikin musamman wanda zaku iya sarrafa wannan hanyar? Tabbas, shirin yana da aiki don canja ƙananan haruffa zuwa babban birnin. Bari mu kalli yadda yake aiki.

Hanyar canji na farkon harafin zuwa taken

Kada kuyi tsammanin cewa a cikin ficelnan akwai maɓallin keɓaɓɓen ta danna kan wanda, zaku iya juya harafin kirtani kai tsaye zuwa taken. Don yin wannan, dole ne ka yi amfani da ayyuka, kuma sau da yawa yanzu. Koyaya, a kowane hali, wannan tafarki tare da sha'awa zai biya farashi na ɗan lokaci wanda za'a buƙace canza bayanai don canza bayanai da hannu.

Hanyar 1: Sauya harafin farko a cikin tantanin

Don magance aikin, ana amfani da babban aikin don maye gurbin, da kuma an sanya ayyukan da aka saka wa ayyukan da aka saka na farkon kuma na biyu an yi rijista kuma Lawsimv.

• Aikin maye gurbin hali yana maye gurbin halaye ɗaya ko ɓangare na layin ga wasu, gwargwadon abin da aka ƙayyade;
• Rajista - Yana sa haruffa a babban birni, wato, babban birni, abin da muke buƙata;
• Lavsimv - ya dawo da adadin adadin haruffan wani rubutu a cikin tantanin halitta.

Wancan shine, dangane da wannan tsarin ayyuka, tare da taimakon Lavsimv, za mu mayar da harafin farko, sannan a maye gurbin ta da aikin don maye gurbin harafin ƙananan zuwa babban jaka.

Janar Tunawa da wannan aikin zai yi kama da wannan:

= Sauya (Old_toxt; nach_post; lamba_ alama; daidai (rubutu; lamba (rubutu; lamba)))

Amma ya fi kyau muyi la'akari da shi duka akan takamaiman misali. Don haka, muna da tebur da aka gama a abin da aka rubuta duk kalmomin da karamin harafi. Muna da alamar farko a cikin kowane tantanin halitta don yin taken. Kwayar farko tare da sunan mahaifi yana da daidaitawa na B4.

1. A kowane wuri na wannan takarda ko a wani takarda, rubuta wannan tsari:

   = Sauya (B4; 1; 1; daidai (Lawsimv (B4; 1)))))



2. Don aiwatar da bayanai ka ga sakamakon, danna maballin Shigar a kan maballin. Kamar yadda kake gani, yanzu a cikin sel, kalmar farko tana farawa da babban harafi.



3. Mun zama siginan sigari zuwa ƙananan kusurwar hagu na tantanin halitta tare da tsari da kuma amfani da cika alamar alamar kwafa da ƙirar ƙananan sel. Dole ne mu kwafa shi daidai da matsayin da aka sanya sel nawa tare da sunan mahaifa suna da teburin haɗin sa.



4. Kamar yadda kake gani, an ba da cewa nassoshi a cikin tsarin dangi, kuma ba cikakken, kwafin ya faru tare da motsi. Sabili da haka, abubuwan da ke cikin matsayi suna biyowa cikin tsari na mukamai a cikin ƙananan sel, amma kuma tare da babban harafi. Yanzu muna buƙatar saka sakamakon a cikin tushen tables. Zaɓi kewayon tare da tsari. Na danna maɓallin linzamin kwamfuta na dama kuma zaɓi "Kwafi" a cikin menu na mahallin.



5. Bayan haka, muna nuna ainihin sel tare da sunaye a cikin tebur. Kira menu na mahallin ta danna maɓallin linzamin kwamfuta dama. A cikin "saka sigogi" toshe, zaɓi abu "dabi'u", wanda ake wakilta azaman gumaka tare da lambobi.



6. Kamar yadda kake gani, bayan wannan, bayanan da muke buƙata an saka su cikin manyan mukamai na tebur. A lokaci guda, ƙananan haruffa a cikin kalmomin farko na sel an maye gurbinsu da babban. Yanzu, kar a lalata bayyanar takardar, kuna buƙatar cire sel tare da tsari. Yana da mahimmanci musamman a goge ko kun yi wani canji a kan takarda ɗaya. Muna haskaka kewayon da aka ƙayyade, danna Dama-Danna kuma a cikin menu na mahallin, dakatar da zaɓi akan "Share ..." abu.



7. A cikin low maganganun da ya bayyana, ka saita canjin "matsayin" matsayi. Latsa maɓallin "Ok".

Bayan haka, za a tsabtace ƙarin bayanan, kuma za mu sami sakamakon da aka cimma: a cikin kowane tebur na farko, kalma ta farko tana farawa da babban harafi.

Hanyar 2: Kowane kalma tare da babban harafi

Amma akwai lokuta lokacin da ya zama dole don sanya kalma ce ta farko a cikin sel, farawa da babban harafin, amma a gabaɗaya, kowace kalma. A saboda wannan, akwai wani bangare na daban, kuma yana da sauki fiye da wanda ya gabata. Wannan fasalin ana kiransa propnant. Syntax mai sauqi ne:

= Shirya (adireshin adireshi)

A kan misalinmu, amfaninsa zai duba kamar haka.

1. Zaɓi yankin kyauta na takardar. Danna kan "saka aiki" icon "icon".



2. A cikin aiki mai aiki na ayyukan, muna neman "raknach". Bayan samun wannan suna, muna ware shi kuma danna maɓallin "Ok".



3. Tagan taga yana buɗe. Mun sanya siginan kwamfuta a filin "rubutu". Select da sel na farko tare da sunan mahaifi a cikin tushe. Bayan adireshinta ya buge taga hujja, danna kan maɓallin Ok.

   

   Akwai wani zaɓi na aiki ba tare da ƙaddamar da maye ba da ayyuka. Don yin wannan, dole ne mu, kamar yadda a hanyar da ta gabata, shigar da aikin da hannu a cikin tantanin halitta tare da rikodin bayanan abubuwan da aka tsara. A wannan yanayin, wannan shigar tana da tsari mai zuwa:

   = Shirya (b4)

   Sannan zaku buƙaci danna maɓallin Shigar.

   Zaɓin wani zaɓi na musamman ya dogara ne akan mai amfani. Ga waɗancan masu amfani da ba a amfani dasu don adana abubuwa daban-daban a kai, a zahiri, yana da sauƙi a yi tare da taimakon waƙar aiki. A lokaci guda, wasu sun yi imani da cewa da sauri fiye da shigarwar mai aiki.

4. Duk abin da zaɓin ya zaɓi, a cikin sel muka karɓi sakamakon da muke buƙata. Yanzu duk sabuwar kalma a cikin sel ta fara da harafin babban jari. A lokacin ƙarshe, kwafa dabara akan sel a ƙasa.



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



6. Saka bayanai ta hanyar "dabi'u" abun da ke saka sigogi cikin jadawalin tushen.



7. Cire ƙwararrun ƙwararru ta menu na mahallin.



8. A cikin sabon taga, tabbatar da cirewar layuka ta hanyar saita canjin zuwa matsayin da ya dace. Danna maɓallin "Ok".

Bayan haka, zamu sami tebur mai canzawa, amma kawai kalmomi ne kawai a cikin sel da aka bi da su tare da harafin babban jari.

Kamar yadda kake gani, duk da cewa Canjin ƙananan haruffa zuwa Exceler da mafi dacewa fiye da canza haruffa da hannu, musamman idan akwai yawa daga gare su. Abubuwan da ke sama da ke sama ba kawai ƙarfin mai amfani ba, amma mafi mahimmanci lokaci lokaci ne. Saboda haka, yana da kyawawa cewa mai amfani na dindindin Excel zai iya amfani da waɗannan kayan aikin a aikinta.