第一个数字元素后分割字符串 [英] Split string after first numeric element
本文介绍了第一个数字元素后分割字符串的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
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)
这篇关于第一个数字元素后分割字符串的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文