EXCEL格式换文本文档TXT格式方法.doc

EXCEL格式转换文本文档TXT格式方法EXCEL格式转换文本文档TXT格式方法如下： 1、打开EXCEL文件---文件---另存为---保存类型 ---选择“文本文件（制表符分隔）”---保存----即TXT文本格式。 2、用WORD方式打开上面已保存的TXT文本文档。 3、选择-编辑---替换- -查找和替换---替换----特殊字符 4、双击“替换”---替换为---在“替换为”的选择框中---输入”。 5、全部替换---确定----关闭“查找和替换”窗口保存文件TXT文本文档格式。在Excel中复制，再在记事本中粘贴，最后保存为文本文件即可，请参阅以下截图， 1.先打开记事本 2.在Excel中整理好资料如图 3.复制资料，注意不包括表头 4.切换到记事本，粘贴 然后编辑- 替换，或者快捷键ctrl+H，复制你粘贴到的txt文档中任意两个单元格内容间的连续几个空格，粘贴到“查找内容”，“替换为”输入“|” 5. 移动鼠标停留到文件最后一行的最后一个字符后面，点击“删除”键删除多余的空格或空行或其他多余字符，保存文件TXT文本文档格式。 urban area 2.5.2 Yibin city in Yibin city, according to resource and environment characteristics Urban population and urban spatial distribution, spatial distribution of industries, major infrastructure Corridor layout, combined with the future development trend of synthetic judgments, planning, urban spatial structure of urban system can be summarized as: a pole along the two axes. A refers to the metropolitan area along the Yangtze River, is the core area of the development of the city. Plans to build for the Yangtze River economic belt on the pillar, advancing along the ... Guanghe River, Yiliang, prestige of the external cohesion of zhaotong, Yunnan, internal connecting Yibin city to the North. The Sichuan-Yunnan-Guizhou border area of Yibin, in the city of zhaotong, liupanshui three, zhaotong city, the most populous and most extensive regions, the most economically backward, to the North in Wumeng mountain area of yanjin, shuifu, suijiang counties radiation power is relatively weak. Yibin city and infrastructure in such areas should be strengthened and docking, extending southward to public services, promote the development of mineral resources in Northeast Yunnan, expand our economic hinterland, driving synchronous lifting in Sichuan-Yunnan-Guizhou border area. This urban axis with mineral resource advantages, focus on the development of advanced technology, comprehensive utilization of resources of higher energy, new building materials, chemical industry, developing new energy and mining