View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
muddan madhu muddan madhu is offline
external usenet poster
 
Posts: 747
Default Adding suffix to column entries

may be ?

=SUBSTITUTE(A2,A2,A2&".jpg") and drag it down





On Oct 13, 4:32*pm, NCdesigner
wrote:
I have a column of 11,000 entries. These are stock numbers for a website
store. The image that goes with each item has the same number. I need to add
".jpg" to even entry in that column without doing it one-by-one. Can anyone
tell me how to do it?
--
NC designer