View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
forxigan forxigan is offline
external usenet poster
 
Posts: 11
Default changing text in multiple cells by pattern

I have excel workbook which contains column of cells with web adresses(as
text, not hyperlinks), which lead to *.jpg files.
All the web links have the exact same adress, except the jpg filename,
for example: http://www.microsoft.com/pics/1.jpg,
http://www.microsoft.com/pics/2.jpg and so on.

Is there a possibility to rename multiple cells by pattern and remove all
text, except the actual filenames(1.jpg, 2.jpg..)?

Thx in advance.