Tse ka Hare
Thupelo ena e tla u tsebisa mekhoa e meraro ea ho tlosa li-carcar ho tloha liseleng tsa Excel. U tla boela u ithute ho fetola likheo tsa mela ka litlhaku tse ling. Litharollo tsohle tse khothalelitsoeng li sebetsa ho Excel 2013, 2010, 2007 le 2003.
Likheo tsa mela li ka hlaha mongolong ka mabaka a fapaneng. Hangata lipoelo tsa likoloi li hlaha bukeng ea mosebetsi, mohlala, ha mongolo o kopitsoa leqepheng la webo, ha o se o le bukeng ea mosebetsi o amoheloang ke moreki, kapa ha rona ka borona re a eketsa ka ho tobetsa linotlolo. Kenya + Alt.
Ho sa tsotellehe hore na lebaka ke lefe, phephetso e teng hona joale ke ho tlosa lipoelo tsa koloi, kaha li kena-kenana le lipatlisiso tsa mantsoe 'me li baka bohlasoa ha ho phuthela.
Mekhoa eohle e meraro e hlahisitsoeng e potlakile haholo. Khetha e u loketseng hantle:
Hlokomela: Qalong, mantsoe a reng "Carriage return" le "Line feed" a ne a sebelisoa ha ho sebetsa mechine ea ho thaepa 'me a bolela liketso tse peli tse fapaneng. 'Mali ea batlang ho tseba a ka iphumanela boitsebiso bo qaqileng mabapi le sena Inthaneteng.
Lik'homphieutha le mananeo a ho sebetsana le mantsoe li entsoe ho nahanoa ka litšobotsi tsa mechine ea ho thaepa. Ke ka lebaka lena litlhaku tse peli tse fapaneng tse sa hatisoeng li se li sebelisoa ho bontša khefu ea mola: koloi e khutlang (Ho khutlisa koloi, CR kapa ASCII khoutu ea 13) le Phetolelo ea line (Phepelo ea line, LF kapa ASCII khoutu 10). Ho Windows, litlhaku ka bobeli li sebelisoa hammoho, 'me lits'ebetsong tsa *NIX, ho sebelisoa mela e mecha feela.
Ela hloko: Likhetho ka bobeli li fumaneha ho Excel. Ha o tlisa ho tsoa lifaeleng .TXT or . Csv data hangata e na le li-carriage returns le line feeds. Ha khefutso ea mohala e kenngoa ka letsoho ka ho tobetsa Kenya + Alt, Excel e kenya feela tlhaku e ncha. Haeba file . Csv e amohetse ho tsoa ho fan ea Linux, Unix kapa sistimi e 'ngoe e ts'oanang, ebe o itokisetsa ho kopana le sebapali se secha feela.
Ho tlosa likoloi tsa likoloi ka letsoho
melemo: Mokhoa ona o potlakile ka ho fetisisa.
tlhoka mesola: Ha ho na melemo e eketsehileng 🙁
Ena ke tsela eo u ka tlosang likheo tsa mela ka eona u sebelisa "Fumana 'me u nkele sebaka":
- Khetha lisele tsohle moo u batlang ho tlosa likariki kapa ho kenya litlhaku tse ling sebakeng sa tsona.
- Press Ctrl + Hho hlahisa lebokose la puisano Fumana 'me u nkele sebaka (Fumana 'me U Emisetse).
- Beha sesupa tšimong Ho fumana (Fumana eng) ebe o tobetsa Ctrl+J. Ha u habanya feela, tšimo e tla bonahala e se na letho, empa ha u e shebisisa, u tla bona letheba le lenyenyane ho eona.
- ka E nkeloe sebaka ke (Fetola With) kenya boleng bofe kapa bofe ho kenya sebakeng sa ho khutlisa kariki. Hangata sebaka se sebelisoa bakeng sa sena ho qoba ho khomarela ka phoso mantsoe a mabeli a bapileng. Haeba u batla feela ho tlosa likheo tsa mela, tloha tšimong E nkeloe sebaka ke (Fetola Ka) e se nang letho.
- ebe o tobetsa konopo Tlosa kaofela (Fetola Tsohle) 'me u natefeloe ke sephetho!
Tlosa likheo tsa mela u sebelisa liforomo tsa Excel
melemo: U ka sebelisa liforomo tse latellanang kapa tse hlophisitsoeng bakeng sa netefatso e rarahaneng ea mongolo ka har'a sele e sebelitsoeng. Mohlala, o ka tlosa lipoelo tsa koloi ebe o fumana libaka tse ling tse etellang pele kapa tse latelang morao, kapa libaka tse ling lipakeng tsa mantsoe.
Maemong a mang, likheo tsa mela li tlameha ho tlosoa e le hore hamorao li sebelise mongolo e le mabaka a sebetsang ntle le ho etsa liphetoho liseleng tsa pele. Sephetho se ka sebelisoa, mohlala, e le khang ea mosebetsi VIEW (SHEBA HOLIMO).
tlhoka mesola: U tla hloka ho theha kholomo ea mothusi le ho etsa mehato e mengata e eketsehileng.
- Kenya kholomo e thusang qetellong ea data. Mohlala oa rona, e tla bitsoa Litsela tse 1.
- Ka seleng ea pele ea kholomo ea tlatsetso (C2), kenya foromo ho tlosa/kenya likheo tsa mela. Ka tlase ho na le liforomo tse 'maloa tse sebetsang bakeng sa liketsahalo tse fapaneng:
- Foromo ena e loketse ho sebelisoa le motsoako oa Windows le UNIX carriage return/line feed.
=ПОДСТАВИТЬ(ПОДСТАВИТЬ(B2;СИМВОЛ(13);"");СИМВОЛ(10);"")=SUBSTITUTE(SUBSTITUTE(B2,CHAR(13),""),CHAR(10),"") - Foromo e latelang e loketse bakeng sa ho nkela sebaka sa ho khaoha ha mola le motho ofe kapa ofe (mohlala, ", " - comma + space). Tabeng ena, mela e ke ke ea kopanngoa 'me libaka tse eketsehileng li ke ke tsa hlaha.
=СЖПРОБЕЛЫ(ПОДСТАВИТЬ(ПОДСТАВИТЬ(B2;СИМВОЛ(13);"");СИМВОЛ(10);", ")=TRIM(SUBSTITUTE(SUBSTITUTE(B2,CHAR(13),""),CHAR(10),", ") - 'Me ke ka moo u ka tlosang litlhaku tsohle tse sa ngolisoeng ho tsoa mongolong, ho kenyelletsa le likheo tsa mela:
=ПЕЧСИМВ(B2)=CLEAN(B2)
- Foromo ena e loketse ho sebelisoa le motsoako oa Windows le UNIX carriage return/line feed.
- Kopitsa foromo ho lisele tsohle tse kholomong.
- Ka boikhethelo, o ka nkela kholomo ea mantlha sebaka ka e ncha, 'me ho tlosoe likheo tsa mela:
- Khetha lisele tsohle kholomong C le ho hatella Ctrl + C kopitsa data ho clipboard.
- E latelang, khetha sele B2, tobetsa sekhechana sa keyboard Shift + F10 eaba kenya (Kenya).
- Hlakola kholomo ea mothusi.
Tlosa likheo tsa mela ka VBA macro
melemo: Etsa hang - sebelisa khafetsa le buka efe kapa efe ea mosebetsi.
tlhoka mesola: Bonyane tsebo ea mantlha ea VBA ea hlokahala.
VBA macro mohlaleng o latelang o tlosa mekotla ea likoloi ho tsoa liseleng tsohle tse leqepheng la mosebetsi le sebetsang.
Sub RemoveCarriageReturns() Dim MyRange As Range Application.ScreenUpdating = False Application.Calculation = xlCalculationManual For Every MyRange In ActiveSheet.UsedRange If 0 < InStr(MyRange, Chr(10)) Then MyRange = Replace(MyRange, Chr(10) ") Qetella Haeba Kopo e Latelang.ScreenUpdating = True Application.Calculation = xlCalculationAutomatic End Sub
Haeba u sa tloaelane le VBA haholo, ke khothaletsa hore u ithute sengoloa se mabapi le mokhoa oa ho kenya le ho etsa khoutu ea VBA ho Excel.