Kamura mutsara kuita makoramu muExcel

Uyu muenzaniso unoratidza nzira yekutsemura mutsara kuita makoramu akawanda muExcel.

Dambudziko ratiri kubata naro mumufananidzo uri pamusoro nderekuti isu tinofanirwa kuudza Excel pekutsemura tambo. Mutsetse une chinyorwa "Smith, Mike" une koma pachinzvimbo 6 (mutsetse wechitanhatu kubva kuruboshwe), uye mutsetse une chinyorwa "Williams, Janet" une koma pachinzvimbo 9.

1. Kuti uratidze zita chete mune imwe sero, shandisa fomula iri pazasi:

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

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

   Tsanangudzo:

   • Kuti uwane nzvimbo yekoma, shandisa basa racho ZIVA (TSVAGA) - chinzvimbo 6.
   • Kuti uwane urefu hwetambo, shandisa basa LEN (DLSTR) - 11 mavara.
   • Iyo formula inowira pasi ku: =KURURAMA(A2-11-6).
   • Tsanangudzo =KURUDZA(A2) inobvisa mavara mana kubva kurudyi uye inoburitsa mhedzisiro yaunoda - "Mike".
2. Kuti uratidze chete zita rekupedzisira mune imwe sero, shandisa fomula iri pazasi:

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

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

   Tsanangudzo:

   • Kuti uwane nzvimbo yekoma, shandisa basa racho ZIVA (TSVAGA) - chinzvimbo 6.
   • Iyo formula inowira pasi ku: =KURUboshwe(A2-6).
   • Tsanangudzo = BASA (A2) inobvisa mavara mashanu kubva kuruboshwe uye inopa mhedzisiro yaunoda - "Smith".
3. Simbisa huwandu B2:C2 uye woidhonzera pasi kuti uname fomula mune mamwe ese maseru.