excel中批量修改数据解决思路

excel中批量修改数据一列数据类似下面的:UploadPic/2012-02-08/132168689584.jpgUploadPic/2012-02-08/132

excel中批量修改数据
一列数据类似下面的:

UploadPic/2012-02-08/132168689584.jpg

 UploadPic/2012-02-08/132168689539.jpg

 UploadPic/2012-02-08/132168689579.jpg 

UploadPic/2012-02-08/132168689580.jpg 

UploadPic/2012-02-08/132168689659.jpg 

UploadPic/2012-02-08/132168689698.jpg

 UploadPic/2012-02-08/132168689611.jpg

 UploadPic/2012-02-08/132168689621.jpg 

UploadPic/2012-02-08/132168689610.jpg 

UploadPic/2012-02-08/132168689658.jpg

批量删除UploadPic 

应该怎么操作?谢谢

[解决办法]
用查找替换 把UploadPic替换成空。