Excel字符串操作: 字符串截取

Categories: Development Notes; Tagged with: Excel • Excel字符串操作; @ February 25th, 2011 15:38

常用方法:

MID(text,start_num,num_chars), 如: =MID(A2,3,1), 截取A2单元格: 从第3个字符开始, 截取一个.

LEFT(text,num_chars), 如:=LEFT(A2, 2)，截取A2单元格左侧链两个字符; 类似的有:

RIGHT(text,num_chars).

可与Find()等方法嵌套使用, 如:

=MID(A1,1,FIND("!",A1)-1): 找到A1单元格中第一个!的位置, 进行截取.

更多Excel文本函数可参考: http://office.microsoft.com/zh-cn/excel-help/HP010342953.aspx

《巨流河》台版电子书PDF+TXT For Kindle&IPad <-> Excel提取两列重复/不同数据

---

ActionScript Adobe AIR ANT Apache ApacheFlex Apache Flex Better Developer BlazeDS Cloud Computing CMD DataGrid DataGridColumn DB2 Derby DTSX Eclipse ETL Event Excel Flash Builder Flex Google Java JDBC JDK JIRA Life@SG|新加坡 Linux MySQL Oracle PHP Python RegEx Servlet SQL SQL Server SSIS SVN T-SQL Tools Tree Ugly WordPress XML dev-notes side-projects