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
|