当前位置：网站首页>Excel intercept text

Excel intercept text

2022-04-23 18:22:00 【Things will turn when they reach the extreme 1024】

Insert picture description here
Take out... From each cell Rx: What follows , obtain
Insert picture description here
The formula ：

=RIGHT(A1,LEN(A1)-FIND("Rx:",A1,1)-2)

analysis ：

RIGHT

RIGHT(text,lenth) Returns a specified number of characters from the right side of a string

FIND

FIND（text,within_text,start_num） lookup within_text stay text The location of
text Source string to process
within_text String to match
start_num Starting position

LEN

LEN(text) text The length of
Finally, I don't know what to reduce 2, This should be the same as what I use Rx: of ,FIND What we found was R The location of , What I really need is : The location of , such within_text How much , I'm going to subtract within_text The length of the minus one

版权声明
本文为[Things will turn when they reach the extreme 1024]所创，转载请带上原文链接，感谢
https://yzsam.com/2022/04/202204210610056900.html

边栏推荐

猜你喜欢

随机推荐