本文介绍了第一个数字元素后分割字符串的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
有人知道Excel中的一个功能可以分开:
Tottenham Court Road 28 Apartment 8
至 Tottenham Court Road 28 和 Apartment 8 ?
像第一个数字 - 分割为另一列之类的东西。
解决方案p>较短版本的公式方法:
左侧
= TRIM(LEFT(A1,FIND(,A1,MIN(IFERROR(FIND({0,1,2,3,4,5,6,7,8,9},A1),))) ))右侧
= TRIM(MID(A1,FIND(,A1,MIN(IFERROR(FIND({0,1,2,3,4,5,6,7,8,9},A1 ),)),LEN(A1)))Ctrl-Shift-Enter)
Does someone know a function in Excel that would separate this:
Tottenham Court Road 28 Apartment 8
to Tottenham Court Road 28 and Apartment 8 ?
Something like "after first number - split to another column".
解决方案Shorter version of the formula approach:
Left side
=TRIM(LEFT(A1,FIND(" ",A1, MIN(IFERROR(FIND({0,1,2,3,4,5,6,7,8,9},A1),"")))))Right side
=TRIM(MID(A1,FIND(" ",A1,MIN(IFERROR(FIND({0,1,2,3,4,5,6,7,8,9},A1),""))),LEN(A1)))Both entered as Array Formulas (press Ctrl-Shift-Enter)
更多推荐
第一个数字元素后分割字符串
发布评论