Chuyển File Log Sang Excel ) (Trực Tuyến Miễn Phí) — Convertio

excel text
Improve this question
asked Jan 31 “13 at 4:10


1,20866 gold badges2424 silver badges5252 bronze badges
Add a comment |

4 Answers 4

Active Oldest Votes
If it”s not too frequent task:

Copy-paste the text to Excel (will occupy one column)Data – Text to Columns (Excel 2003) Delimiters: Comma and Other: >After completing the operations, insert a column after the remaining non-splitted fragment (358920045121212<0.75) and repeat Text to Columns for this column only with Other delimiter as <.
Improve this answer
answered Jan 31 “13 at 6:54


Jüri RuutJüri Ruut
2,3901515 silver badges1919 bronze badges
Add a comment |
1) Copy the data into a text file, like Notepad.

Đang xem: Chuyển file log sang excel

2) Use find and replace to replace bracket characters with a tab character.You can not directly type a tab character into the replace field, because it will just move your cursor to the next field. To get around this:Open another Notepad window and press tab, then copy the tab into the replace field of the original Notepad window. Hit replace and repeat this process with space and comma characters.

3) Save and close the notepad file.

4) Open the notepad file in Excel. (choose file, open, and don”t forget to change the file type in the open dialog from “All Excel Files” to “All Files”

5) This will open the Text Import Wizard. Hit next, next and finished, and the data should show up in separate columns

Improve this answer
answered Jan 31 “13 at 4:29


20711 silver badge88 bronze badges
Add a comment |
If you want to do it strictly in Excel, you will have to extract the individual data elements from each string using a combination of text functions, including SEARCH or FIND, LEFT, MID and RIGHT. The following formulas show one wqy to extract each element from one of the strings, which I have assumed is in A1.

=MID(A1,2,SEARCH(“,”,A1)-2) =MID(A1,SEARCH(“,”,A1)+1,SEARCH(“>”,A1)-SEARCH(“,”,A1)-1) =MID(A1,SEARCH(“>”,A1)+1,SEARCH(“>”,A1)+SEARCH(“<",MID(A1,SEARCH(">“,A1),99))-SEARCH(“>”,A1)-2) =MID(A1,SEARCH(“<",A1,2)+1,SEARCH(">“,MID(A1,SEARCH(“<",A1,2)+1,99))-1) =MID(A1,SEARCH("????-??-??",A1),10) =RIGHT(A1,8)You would enter these formulas horizontally to the right of A1, then copy them down.

Improve this answer
answered Jan 31 “13 at 4:37


5,70611 gold badge1818 silver badges2626 bronze badges
Add a comment |
There is a much simpler way – use a third party piece of software.

The one I used costs me very little for the year, but means i don”t need to mess around with trying to get it right.

Xem thêm: Top 200+ Game Offline Pc Full free Hay Mới Nhất Cập Nhật 2020

Its the only tool i found which isn”t a monthly subscription as well.

Its a desktop based application.

Improve this answer
answered Jan 26 “19 at 15:11


Andy HallidayAndy Halliday
Add a comment |

Your Answer

Thanks for contributing an answer to Stack Overflow!

Please be sure to answer the question. Provide details and share your research!

But avoid

Asking for help, clarification, or responding to other answers.Making statements based on opinion; back them up with references or personal experience.

To learn more, see our tips on writing great answers.

Xem thêm: Đăng Nhập Game Center Bằng Gmail, Google Product Forums

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Facebook
Sign up using Email and Password

Post as a guest

Email Required, but never shown

Post as a guest


Required, but never shown

Post Your Answer Discard

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged excel text or ask your own question.

The Overflow Blog
Featured on Meta
How to split string into separate cells
How do I create an Excel (.XLS and .XLSX) file in C# without installing Microsoft Office?
Import Excel spreadsheet columns into SQL Server database
How to import an excel file in to a MySQL database
Print string to text file
Is it possible to force Excel recognize UTF-8 CSV files automatically?
'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine
How do I find all files containing specific text on Linux?
How to correctly display .csv files within Excel 2013?
How to use Regular Expressions (Regex) in Microsoft Excel both in-cell and loops
Hot Network Questions more hot questions

Question feed
Subscribe to RSS
Question feed To subscribe to this RSS feed, copy and paste this URL into your RSS reader.

Stack Overflow
Stack Exchange Network
site design / logo © 2021 Stack Exchange Inc; user contributions licensed under cc by-sa. rev2021.4.12.39055

Stack Overflow works best with JavaScript enabled


Your privacy

By clicking “Accept all cookies”, you agree Stack Exchange can store cookies on your device and disclose information in accordance with our Cookie Policy.

Xem thêm bài viết thuộc chuyên mục: Chuyển file

Khuyễn Mãi Hot