how to in exel

[Guest]

in exel i have a colum of 1000 combinations of letters ( hjdbud ) and so on i
want to add .jpg to all of these in this colum, i know the code is A1=&".jpg"
in anouther row but then in lost on how to do the rest please help

morefeus

 

[Guest]

If you have that list in Column A starting in row 1 then on column B row 1put:

=A1&".jpg"

and drag down as far as you need

 

[Don Guillett]

try this

for each c in range("a2:a100")
c.value=c & ".jpg"
next c

 

[Bob Phillips]

see response in worksheet.functions


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)