Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how 2 convert (exel macro's mysql) ?? | Excel Discussion (Misc queries) | |||
how do I convert a non exel tabulation to exel | New Users to Excel | |||
exel reader | Excel Discussion (Misc queries) | |||
Need help with exel database | Excel Discussion (Misc queries) | |||
Need help with exel database | Excel Discussion (Misc queries) |