如何提取单元格中有这些图片目录地址

yytx1106

王帅波 发表于 2016-12-25 20:48
自定义函数可以，用内置函数我没想出来怎么弄，你把这段字复制给我，我研究一下

<div style="color:#000000;font-size:14.285715px;line-height:20.0px;text-align:center;"> <div style="font-size:14.285715px;">  <span style="line-height:1.5;"></span>  <div style="margin:0.0px;padding:0.0px;font-size:14.285715px;">   <strong><span style="font-size:24.0px;"><span style="font-family:simhei;"><span style="background-color:#000000;"><span style="background-color:#ffffff;">【发快递直接拍下，发物流找客服协商】</span></span></span></span></strong>  </div>  <div style="margin:0.0px;padding:0.0px;font-size:14.285715px;">   <strong><span style="font-size:24.0px;"><span style="font-family:simhei;"><span style="background-color:#000000;"><span style="background-color:#ffffff;"></span></span></span></span></strong>  </div>  <div style="margin:0.0px;padding:0.0px;font-size:14.285715px;">   <span style="color:#ff0000;"><strong><span style="font-size:24.0px;"><span style="font-family:simhei;"><span style="background-color:#000000;"><span style="background-color:#ffffff;">包邮地区：</span></span></span></span></strong></span>  </div>  <div style="margin:0.0px;padding:0.0px;font-size:14.285715px;">   <strong><span style="font-size:24.0px;"><span style="font-family:simhei;"><span style="background-color:#000000;"><span style="background-color:#ffffff;">（河南、江苏、浙江、上海、安徽、北京、天津、 湖北、山东、河北、广东、山西、陕西、湖南</span></span></span></span></strong>   <strong style="font-size:14.285715px;"><span style="font-size:24.0px;"><span style="font-family:simhei;"><span style="background-color:#000000;"><span style="background-color:#ffffff;">、福建</span></span></span></span></strong>   <strong style="font-size:14.285715px;"><span style="font-size:24.0px;"><span style="font-family:simhei;"><span style="background-color:#000000;"><span style="background-color:#ffffff;">），</span></span></span></span></strong>  </div>  <div style="margin:0.0px;padding:0.0px;font-size:14.285715px;">   <strong><span style="font-size:24.0px;"><span style="font-family:simhei;"><span style="background-color:#000000;"><span style="background-color:#ffffff;"></span></span></span></span></strong>  </div>  <div style="margin:0.0px;padding:0.0px;font-size:14.285715px;">   <span style="color:#ff0000;"><strong><span style="font-size:24.0px;"><span style="font-family:simhei;"><span style="background-color:#000000;"><span style="background-color:#ffffff;">拍下店铺默认发【百世汇通、中通</span></span></span></span></strong></span>   <strong style="color:#ff0000;font-size:14.285715px;"><span style="font-size:24.0px;"><span style="font-family:simhei;"><span style="background-color:#000000;"><span style="background-color:#ffffff;">】。</span></span></span></span></strong>  </div>  <div style="margin:0.0px;padding:0.0px;font-size:14.285715px;">   <strong><span style="font-size:24.0px;"><span style="font-family:simhei;"><span style="background-color:#000000;"><span style="background-color:#ffffff;"></span></span></span></span></strong>  </div>  <div style="margin:0.0px;padding:0.0px;font-size:14.285715px;">   <strong><span style="font-size:24.0px;"><span style="font-family:simhei;"><span style="background-color:#000000;"><span style="background-color:#ffffff;">【其他地区】满10个以上物流包邮</span></span></span></span></strong>   <strong style="font-size:14.285715px;"><span style="font-size:24.0px;"><span style="font-family:simhei;"><span style="background-color:#000000;"><span style="background-color:#ffffff;">，请找客服免邮</span></span></span></span></strong>   <strong style="font-size:14.285715px;"><span style="font-size:24.0px;"><span style="font-family:simhei;"><span style="background-color:#000000;"><span style="background-color:#ffffff;">。</span></span></span></span></strong>  </div>  <div style="margin:0.0px;padding:0.0px;font-size:14.285715px;">   <strong style="font-size:14.285715px;"><span style="font-size:24.0px;"><span style="font-family:simhei;"><span style="background-color:#000000;"><span style="background-color:#ffffff;">（青海、新疆、西藏除外）&nbsp;<img align="absmiddle" src="file:///D:/淘宝归象过河/兴宁1225/淘宝助理5201612251549/contentPic/粪地板塑料漏粪板新料16751/1675181e579-1.jpg" size="600x600" /></span></span></span></span></strong>  </div> </div> <div style="font-size:14.285715px;">  <span style="line-height:1.5;">&nbsp;</span>  <img align="absmiddle" style="line-height:1.5;" src="file:///D:/淘宝归象过河/兴宁1225/淘宝助理5201612251549/contentPic/粪地板塑料漏粪板新料16751/1675181e579-2.jpg" size="600x600"><img align="absmiddle" src="file:///D:/淘宝归象过河/兴宁1225/淘宝助理5201612251549/contentPic/粪地板塑料漏粪板新料16751/1675181e579-3.jpg" size="600x600"><img align="absmiddle" src="file:///D:/淘宝归象过河/兴宁1225/淘宝助理5201612251549/contentPic/粪地板塑料漏粪板新料16751/1675181e579-4.jpg" size="600x600"><img align="absmiddle" src="file:///D:/淘宝归象过河/兴宁1225/淘宝助理5201612251549/contentPic/粪地板塑料漏粪板新料16751/1675181e579-5.jpg" size="600x600"> &nbsp;<img align="absmiddle" style="line-height:1.5;" src="file:///D:/淘宝归象过河/兴宁1225/淘宝助理5201612251549/contentPic/粪地板塑料漏粪板新料16751/1675181e579-6.jpg" size="600x600"><img align="absmiddle" style="line-height:1.5;" src="file:///D:/淘宝归象过河/兴宁1225/淘宝助理5201612251549/contentPic/粪地板塑料漏粪板新料16751/1675181e579-7.jpg" size="600x600"><img align="absmiddle" style="line-height:1.5;" src="file:///D:/淘宝归象过河/兴宁1225/淘宝助理5201612251549/contentPic/粪地板塑料漏粪板新料16751/1675181e579-8.jpg" size="600x600"><img align="absmiddle" style="line-height:1.5;" src="file:///D:/淘宝归象过河/兴宁1225/淘宝助理5201612251549/contentPic/粪地板塑料漏粪板新料16751/1675181e579-9.jpg" size="600x600"><img align="absmiddle" style="line-height:1.5;" src="file:///D:/淘宝归象过河/兴宁1225/淘宝助理5201612251549/contentPic/粪地板塑料漏粪板新料16751/1675181e579-10.jpg" size="600x600"><img align="absmiddle" style="line-height:1.5;" src="file:///D:/淘宝归象过河/兴宁1225/淘宝助理5201612251549/contentPic/粪地板塑料漏粪板新料16751/1675181e579-11.jpg" size="600x600"><img align="absmiddle" style="line-height:1.5;" src="file:///D:/淘宝归象过河/兴宁1225/淘宝助理5201612251549/contentPic/粪地板塑料漏粪板新料16751/1675181e579-12.jpg" size="600x600"><img align="absmiddle" style="line-height:1.5;" src="file:///D:/淘宝归象过河/兴宁1225/淘宝助理5201612251549/contentPic/粪地板塑料漏粪板新料16751/1675181e579-13.jpg" size="600x600"><img align="absmiddle" style="line-height:1.5;" src="file:///D:/淘宝归象过河/兴宁1225/淘宝助理5201612251549/contentPic/粪地板塑料漏粪板新料16751/1675181e579-14.jpg" size="600x600" /> </div></div>

我的城市你来过

=REGEXP(A2,"(?<=D:/).+?(?=[jpg]+)")