View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
RHD3 RHD3 is offline
external usenet poster
 
Posts: 5
Default adding a,b,c,etc to end of item in call

I have two columns. Col A is "acct nos" where some acct nos are repeated 2,3
or 4 times and some only twice. The second column is random file names, such
as 0001325.jpg. I would like to be able to to rename the 2nd column with the
1st column acct no name and add an a,b,c, etc(however many times the account
no is listed). my "new" name would be something like 0100252401a.jpg,
0100252401b.jpg, etc.
Thanks