excel中批量批改数据

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

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替换成空。