Gawani mizere kukhala mizere mu Excel

Chitsanzochi chikuwonetsa momwe mungagawire mzere kukhala magawo angapo mu Excel.

Vuto lomwe tikukumana nalo pachithunzi pamwambapa ndikuti tiyenera kuuza Excel komwe angagawire chingwecho. Mzere wokhala ndi mawu oti "Smith, Mike" uli ndi koma pamalo 6 (munthu wachisanu ndi chimodzi kuchokera kumanzere), ndipo mzere wokhala ndi mawu akuti "Williams, Janet" uli ndi koma pamalo 9.

  1. Kuti muwonetse dzina lokha mu selo lina, gwiritsani ntchito njira yomwe ili pansipa:

    =RIGHT(A2,LEN(A2)-FIND(",",A2)-1)

    =ПРАВСИМВ(A2;ДЛСТР(A2)-НАЙТИ(",";A2)-1)

    Kufotokozera:

    • Kuti mupeze pomwe pali koma, gwiritsani ntchito ntchitoyi DZIWANI (PEZANI) - malo 6.
    • Kuti mupeze kutalika kwa chingwe, gwiritsani ntchito ntchitoyi LEN (DLSTR) - zilembo 11.
    • Fomula imafikira ku: =KUYERA (A2-11-6).
    • mawu =KUYERA(A2) amachotsa zilembo 4 kumanja ndikutulutsa zomwe mukufuna - "Mike".
  2. Kuti muwonetse dzina lomaliza mu selo lina, gwiritsani ntchito fomu ili pansipa:

    =LEFT(A2,FIND(",",A2)-1)

    =ЛЕВСИМВ(A2;НАЙТИ(",";A2)-1)

    Kufotokozera:

    • Kuti mupeze pomwe pali koma, gwiritsani ntchito ntchitoyi DZIWANI (PEZANI) - malo 6.
    • Fomula imafikira ku: =KUmanzere(A2-6).
    • mawu = KUMANYA (A2) amatulutsa zilembo 5 kumanzere ndikupereka zotsatira zomwe mukufuna - "Smith".
  3. Onetsani mtundu b2:c2 ndi kukokera pansi kuti muyike chilinganizocho m'maselo ena onse.

Siyani Mumakonda