MacGyver akaishandisa. Vashandi veApollo 13 vakaishandisawo. Nguva dzose mumamiriro ezvinhu akaoma, kana iwe uchida kubatanidza zvinhu zviviri, vanhu vanotora tepi. Unogona kushamisika, asi Excel ine yakavakirwa-mukati basa rinoita zvakafanana. Iri ibasa CONCATENATE (CUTCH).
basa CONCATENATE (CONCATENATE) inokutendera kuti ubatanidze zvidimbu zviviri kana kupfuura zvemavara musero rimwe. Pasinei nezita rakareba, zviri nyore kwazvo kushandisa uye zvinoshanda zvakafanana mumavhezheni ese eExcel pamwe nemamwe maspredishiti akadai seGoogle Sheets.
Cherechedza: Kana usati wamboshandisa Excel mabasa kare, unogona kutarisa kune chikamu Formulas uye Mabasa Ona yedu Excel Tutorial yeVanotanga kune akatevedzana edzidziso pane iyi nyaya.
Kubatanidza mazita
Ngatitii tine tafura ine ruzivo rwekusangana apo mazita ekutanga nerekupedzisira ari mumakoramu akasiyana. Tinoda kuvabatanidza towana zita rizere remunhu wega wega. Pamufananidzo uri pazasi unoona mazita ari mukoramu B, nemazita ekupedzisira muchikamu A. Formula yedu inenge iri muchitokisi E2.
Tisati tatanga kupinda mufomula, nzwisisa pfungwa inokosha: basa STsEPIT zvinongosunga izvo zvaunotsanangura uye hapana chimwe. Kana uchida zviratidzo zvepumikira, nzvimbo, kana chimwewo chinhu kuti chibude murusero, zviwedzere kunharo dzebasa.
Mumuenzaniso uyu, tinoda nzvimbo pakati pemazita (kudzivisa chimwe chinhu se-- JosephineCarter), saka tichada kuwedzera nzvimbo kune nharo. Nokudaro, tichava nenharo nhatu:
- B2 (Zita rekutanga) - zita
- "" - hunhu hwenzvimbo mumakotesheni
- A2 (Zita rekupedzisira) - surname
Iye zvino kuti nharo dzatsanangurwa, tinogona kunyora kune sero E2 heino formula:
=CONCATENATE(B2," ",A2)
=СЦЕПИТЬ(B2;" ";A2)
Sezvimwe nerimwe basa reExcel, syntax yakakosha. Rangarira kutanga nechiratidzo chakaenzana (=) woisa delimiters (comma kana semicolon) pakati penharo.
Cherechedza: isa koma kana semicolon pakati penharo - zvinoenderana nenyika yaunogara uye kuti ndeipi vhezheni yeExcel yaunoshandisa.
Ndizvo zvose! Paunodzvanya pinda, zita rakazara richaonekwa: Josephine Carter.
Zvino, nekukweva mubato wekuzadza otomatiki, kopira fomula kune ese maseru kusvika E11. Nekuda kweizvozvo, zita rakazara richaonekwa kumunhu wega wega.
Kana iwe uchida kuomesa basa, saka edza kushandisa basa STsEPIT batanidza guta nenyika muchikamu Fkutaridzika semufananidzo uri pazasi:
Kubatanidza nhamba uye zvinyorwa
Kushandisa mabasa STsEPIT Unogona kubatanidza nhamba uye zvinyorwa. Ngatimbofungidzira kuti isu tinoshandisa Excel kuchengetedza zvinyorwa zvechitoro. Iye zvino tawana Apple 25 (maapuro), asi nhamba "25" uye shoko rokuti "maapuro" anochengetwa mumasero akasiyana. Ngatiedzei kuvabatanidza muchitokisi chimwe kuti tiwane chinhu chakadai:
Tinofanira kubatanidza zvinhu zvitatu:
- F17 (Nhamba mustock) - huwandu
- "" - hunhu hwenzvimbo mumakotesheni
- F16 (Chigadzirwa) - zita
Isa fomura inotevera musero E19:
=CONCATENATE(F17," ",F16)
=СЦЕПИТЬ(F17;" ";F16)
Ngatiomese! Ngatitii tinoda kuwana: Tine maapuro makumi maviri nemashanu (Tine maapuro makumi maviri nemashanu). Kuti uite izvi, unofanirwa kuwedzera imwe nharo - mutsara wekuti "Tine":
=CONCATENATE("We have ",F17," ",F16)
=СЦЕПИТЬ("We have ";F17;" ";F16)
Iwe unogona kuwedzera dzimwe nharo kana iwe uchida kugadzira chirevo chakaoma. Chinhu chikuru chekurangarira ndechekuti iyo syntax yefomati inofanirwa kuve yakanyatso kurongeka, zvikasadaro inogona kusashanda. Zviri nyore kukanganisa mune yakakura formula!