how to in exel
 

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

how to in exel
 

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

how to in exel
 

try this

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

--
Don Guillett
SalesAid Software

"Morefeus Direct" wrote in
message ...
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

how to in exel
 

see response in worksheet.functions


--
HTH

Bob Phillips

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

"Morefeus Direct" wrote in
message ...
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