Koj tau raug ua haujlwm nrog tsim cov lus teev tseg ntawm txhua tus neeg ua haujlwm ntawm cov neeg ua haujlwm siv cov Microsoft Office Excel spreadsheet editor. Ua ntej tsim lub rooj, koj suav cov kab uas yuav tsum muaj ntawm kab ntawv thiab tsim nws. Tab sis koj tus thawj coj xav kom koj faib ib kem "Surname First name Patronymic" ua 3 ntu. Txhawm rau faib lub xov tooj ntawm tes kom nrawm rau hauv MS Word, nyeem kab lus sib tshooj.
Tsim nyog
Microsoft Office Excel software
Cov Lus Qhia
Kauj ruam 1
Cia peb txuas ntxiv ua haujlwm nrog peb cov lus, hauv qhov nws yog qhov tsim nyog los hloov cov nqi ntawm kem "Surname First Name Patronymic". Koj yuav tsum tau txiav txim siab los ntawm lub ntsiab lus "Petrov Petr Petrovich" - "Petrov", "Peter" thiab "Petrovich". Nyem rau ntawm lub xov tooj koj yuav raug rhuav tshem.
Kauj ruam 2
Hauv cov ntawv qhia zaub mov tseem ceeb ntawm Microsoft Excel, xaiv kab "Cov Ntaub Ntawv" - mus rau "Ua Haujlwm nrog cov ntaub ntawv" pab pawg - xaiv cov khoom "Cov Ntawv ntawm Cov Ntawv".
Kauj ruam 3
Hauv "Phau Ntawv Qhia Cov Cuab Yeej (xav tau) - kauj ruam 1 ntawm 3" qhov rai uas tshwm sim, mus rau "Cov ntaub ntawv ntawm cov ntaub ntawv" cov pab pawg - tom qab ntawd xaiv cov "Delimited" add-in - nyem lub pob "Next".
Kauj ruam 4
Nyob rau hauv lub qhov rai "Cov Lus Qhia Ua Dab Tsi (ntu) - kauj ruam 2 ntawm 3" mus rau pab pawg "Lub cim yog cais" - khij lub npov nyob ib sab ntawm cov khoom "chaw" (Ntawm no koj yuav tsum xaiv lub cim uas cais cov lus hauv lub xov tooj ntawm tes uas peb xav tawg (rooj plaub, xws li tus xeeb ceem yog chaw). Tom qab ua tiav cov kauj ruam no, nyem lub khawm Finish.
Kauj ruam 5
Lub chaw nruab ntug yuav kaw, saib qhov tshwm sim ntawm kev ua haujlwm. Yog tias lub xovtooj ntawm tau faib cais tsis raug, rov qab dhau los ua haujlwm kawg (los ntawm nias lub pob nyem shortcut Ctrl + I) thiab sim dua ua cov haujlwm no.
Kauj Ruam 6
Raws li qhov tshwm sim ntawm kev nqis tes ua, koj tau txais kev faib tawm ntawm lub xovtooj rau hauv qhov chaw sib cais, raws li cov kev ntsuas tshwj xeeb.
