Thread: exel help
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Richard Buttrey Richard Buttrey is offline
external usenet poster
 
Posts: 296
Default 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
__________________________