TMT to excelHere are a few ways to convert txts to excel and sort them out:
** 1. Use the data import wizard **
1. ** Choose Data Source **
- In Excel, click the [Data] tab, select [Obtain Data]-[From a file]-[From Text/dsv], and then select the TMT file that needs to be modified and confirm to enter the [Text import wizard] interface.
2. ** Confirm Separator **
- Observe how the imported content is separated. For example, if the name, contact information, department, and other information are separated by spaces, select [Space] in the [Separator] column on the [Text import wizard] page, and then click [load].
- If the content in the TMT is separated by the Chinese symbol ",", enter the "Text import wizard", select the "Separator", click "Next", and then select "Other", enter a coma, and click "Finish". If it was a space, a semi-colon and a commas in English could be directly checked.
** 2. First copy and paste before sorting **
1. ** Copy-paste content **
- First, he copied the contents of the txt-text by pressing and pressing Ctrl-C, and then pressed and pressed Ctrl-V to paste it into the Excel document.
2. ** Split operation **
- After selecting the pasted content, he chose Data-Split, clicked Next, and selected the corresponding operation according to the content's splitter. For example, he selected Other and entered the corresponding splitter, and finally clicked Finish.
** 3. Dealing with special circumstances **
1. ** Conversion from text to numbers **
- If the cell format was found to be text format before splitting, set it to regular format before splitting.
2. ** Processing of Continuous Separators **
- If there are continuous separating symbols in the data, such as the number of spaces in the middle of the data is inconsistent, you can check the option of "Treating continuous separating symbols as a single process" when sorting.
3. ** Special Character Separation **
- For example, when the golden tax tray was used to export the commodity code data, it used two "~~" as the separating characters. It was necessary to first replace the two "~~" with one "~"(In Excel,"~" was an escape character. If one wanted to replace a "~", one had to enter "~~" in the replacement box) before separating the data.
<a href="/?from=ask_words" style="color:red" target="_blank">Read more exciting novels for free</a>
Sering terbalik penulisan nama, saat terjadi perkelahian... Antara nama jagoan dan penyerang. Jangan terlalu sering mengulang penjelasan yang sudah dijelaskan pada bab-bab sebelumnya. Thanks