Excel截取字符求助

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

送您一个全额奖学金名额~ !

立即领取

感谢您参与论坛问题回答

经管之家送您两个论坛币！

+2 论坛币

例如：Http://aaaa/bbbb/cccc/dddd    http://aaaa/bbbb/cccc/dddd/eeeee
我怎么截取从右算起第二个/和第三个/之间的字符

扫码加我 拉你入群

请注明：姓名-公司-职位

以便审核进群资格，未注明则拒绝

分享0 收藏0 回帖

关键词：EXCEL xcel exce cel HTTP Excel eeeee

Copy the string into a cell. Use Data-Text to column, select delimited, use the / as the separator. You can see all the contents between each /.

ArielStudy 发表于 2017-1-13 07:56
Copy the string into a cell. Use Data-Text to column, select delimited, use the / as the separator.  ...

thx, But I'll get the String between the 2th "/" and 3th "/" from right side to left side.
if  every row have not same number of "/", then get wrong result!

试试看附件。
Answer Dekenstr.xlsx (9.16 KB)

2017-1-20 14:18:24 上传

好厉害

C8=TRIM(MID(SUBSTITUTE(B8,"/",REPT(" ",2*LEN(B8))),2*LEN(B8)*(LEN(B8)-LEN(SUBSTITUTE(B8,"/",""))-2),LEN(B8)))