(求助)如何能将以下单元格中所需要内容一次性挑出来？

fuyuehuman

(求助)如何能将以下单元格中所需要内容一次性挑出来？

URL

http://wap.3g.qq.com/waptest/server?sid=

http://wap3.3g.qq.com/waptest/server?sid

http://218.200.244.92/PullServlet;xid=Gv

http://218.200.244.82/picserver/cms/uplo

http://61.144.222.42:8090/images/moonlig

http://219.133.62.123:8080/images/face/o

http://211.139.167.69/pic/images/service

http://wap.monternet.com/

http://219.133.62.123:8080/images/online

http://wap.monternet.com/reversesubscrib

如上这些网址，我想把他做成只需要门户网址的效果如下：

wap.3g.qq.com

wap3.3g.qq.com

218.200.244.92

218.200.244.82

61.144.222.42:8090

219.133.62.123:8080

211.139.167.69

wap.monternet.com

219.133.62.123:8080

请问在ACCESS中用什么样的函数可以把以上内容一次性筛选出来啊？

sgrshh29

=split("URL","/")(2)