View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] gartnerkalender@gmail.com is offline
external usenet poster
 
Posts: 1
Default How to add prefix to names in a column

I have 1000 plant names in a column I want to add the prefix "http://www.google.com/images?q=" to

So

"Acer Campestre"

and so on become

http://www.google.com/images?q=Acer Campestre

This is a one time operation, as I will copy all these links to somewhere else.