Kidokezo: Lugha zingine ni Google-Ilitafsiriwa. Unaweza kutembelea English toleo la kiungo hiki.
Ingia
x
or
x
x
Daftari
x

or

Haraka kupiga au kupanua majina ya kwanza, ya kati na ya mwisho ya jina kamili katika Excel

Wakati unatumia Microsoft Excel, unaweza kugawanya safu moja kwenye nguzo tofauti kulingana na yaliyomo ya seli. Kama skrini iliyo hapo chini inavyoonyeshwa, unaweza kugawanya majina kamili kwenye safu kwa safu ya kwanza, katikati na jina la mwisho tofauti kama unahitaji.

Hapa tutakupendekeza Split Majina matumizi ya Kutools kwa Excel, na shirika hili, unaweza kugawanya kwa urahisi majina kamili katika safu ya safu ya kwanza, ya kati na ya mwisho mara moja, na itaongeza ufanisi wa kazi yako.

Piga jina la kwanza, la kati na la mwisho la jina kamili katika Excel


Bonyeza Kutools > Nakala > Split Majina. Angalia skrini:

fanya mshale wa kulia risasi kupasuliwa majina 2


Piga jina la kwanza, la kati na la mwisho la jina kamili katika Excel

Ikiwa una orodha ya majina kamili ambayo yanajumuisha majina ya kwanza, ya kati na ya mwisho katika upeo wa A2: A10. Kwa urahisi kugawanya majina haya kamili katika nguzo tofauti, tafadhali fanya kama ifuatavyo.

1. Tafadhali chagua seli za jina utazigawanya, na bofya Kutools > Nakala > Split Majina ili kuwezesha Split Majina sanduku la mazungumzo.

2. Ndani ya Split Majina sanduku la mazungumzo, angalia Jina la kwanza, Katikati jina na Jina la mwisho masanduku kama unahitaji, kisha bofya OK button.

Vidokezo:

(1) Mbali na kugawanyika majina ya kwanza, ya kati na ya mwisho pamoja, unaweza kugawanya moja tu kwa kuangalia tu chaguo husika.

(2) Ikiwa haukuchagua seli za jina katika hatua ya kwanza, unaweza kubofya kuvinjari kifungo nyuma ya Panga kwa Kugawanya sanduku kuchagua seli za jina.

3. Chagua kiini maalum ambacho unataka data iliyokatenganishwa, kisha bofya OK button.

Utaona majina kamili yaliyochaguliwa yanajitenga kwa majina ya kwanza, ya kati na ya mwisho mara moja na iko kwenye safu zilizowekwa. Angalia skrini:


Zana za Uzalishaji Zilizopendekezwa
Vifaa vifuatavyo vinaweza kuokoa muda na pesa yako, ni moja ambayo ni sawa kwako?
Tabia ya Ofisi: Kutumia vichupo vyema katika Ofisi yako, kama njia ya Chrome, Firefox na New Internet Explorer.
Kutools kwa Excel: Zaidi ya kazi za juu za 300 kwa Excel 2019, 2016, 2013, 2010, 2007 na Ofisi 365.
Menyu ya Classic ya Ofisi: Kurudia menus familiar kwa Ofisi 2007, 2010, 2013, 2016, 2019 na 365, kama ilivyo Ofisi ya 2000 na 2003.

Kutools kwa Excel

Kazi iliyoelezwa hapo juu ni moja tu ya kazi za 300 za Kutools kwa Excel.

Iliyoundwa kwa Excel (Ofisi) 2019, 2016, 2013, 2010, 2007 na Ofisi ya 365. Pakua na kupakua kwa siku za 60.

Screen shot ya Kutools kwa Excel

btn kusoma zaidi Btn shusha ununuzi wa btn

Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.
  • To post as a guest, your comment is unpublished.
    Kunal Shah · 1 years ago
    Hi. I have an excel issue. I have the following in one cell. "JohnDoe" I need to separate the first name and last name into two columns. The first letter of the first name and the first letter of the last name are capitalized. How can I do this?


    Example:


    JohnDoe ---- Need it to be John Doe
    MichaelJordan ---- Need it to be Michael Jordan
    TomSmith ---- Need it to be Tom Smith
  • To post as a guest, your comment is unpublished.
    Barnett Frankel · 1 years ago
    I have a spreadsheet and every 6th line has a county name, state, and other information. I need to extract just the county name and place it 5 lines down in column A, e.g., B22 = Clinton County, ILLINOIS, EPA Region5. Only the word 'Clinton' needs to be extracted and then pasted to A26. There are 549 rows of data, each county is 6 rows.
    • To post as a guest, your comment is unpublished.
      Admin_jay · 1 years ago
      [quote name="Barnett Frankel"]I have a spreadsheet and every 6th line has a county name, state, and other information. I need to extract just the county name and place it 5 lines down in column A, e.g., B22 = Clinton County, ILLINOIS, EPA Region5. Only the word 'Clinton' needs to be extracted and then pasted to A26. There are 549 rows of data, each county is 6 rows.[/quote]
      Can you please try to create some sample data in new workbook?

      Please attached the workbook in your email with detailed informaiton via jaychivo@extendoffice.com