Thread: exel help
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default exel help

in B1 use =A1&".jpg"

Copy down.

Select column B, and copy

Goto editPasteSpecila, and click Values, then OK

Delete column A

--
HTH

Bob Phillips

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

"Morefeus Direct" wrote in
message ...
Hi i'm working in exel, i have a column(A1) with these type of info in the
column ( hbdn3j , hdfeyb , ijdnhf33k ) , and so on all the way down to

1000,
now i need to add to the end of these (.jpg ) all the way down 1000 sets.
How can i do this without going one by one and adding the ( .jpg ), i

know
there is a code to do this i think its, A1=&".jpg" i've used it before

but i
can't remember what to do with the code afterwards.

HELP!!!
Marshall