摘要: VBA can read a text file and then write it to your spreadsheet. Here's an example of a VBA program that shows how to do it.http://exceluser.com/excel_... 阅读全文
posted @ 2014-11-30 20:14 jefflu99 阅读(415) 评论(0) 推荐(0) 编辑
摘要: " =IF(LEN(B3)=23,B3,A3&" "&B3&REPT(" ",23-LEN(B3))&C3) &&&&&&& verify the char length of material " =IF(LEN(A3)=5,A3,A3&REPT(" ",5-LEN(A3))) *********... 阅读全文
posted @ 2014-11-30 19:56 jefflu99 阅读(282) 评论(0) 推荐(0) 编辑