exel help
On Sat, 21 Oct 2006 08:40:02 -0700, Morefeus Direct
wrote:
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
Nearly right. Code would be
=A1&".jpg"
Then to convert them all to text values, just copy A1:A1000 and Edit
PasteSpecial Values to A1
HTH
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________
|