View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Morefeus Direct
 
Posts: n/a
Default How do i add to information to microsoft exel worksheet

hi, Pete still tying to do this and i know its realy simple but i'm very new
at this , could you please give some directions that a newbe like myself can
follow, very discriptive .

thanks

"Pete_UK" wrote:

You can use a helper column to do this. Assuming your data is in column
A, in another blank column you can enter this formula in cell 1:

=A1&".jpg"

Then copy this formula all the way down to the bottom of your data.
Highlight all the cells with this formula in and click <copy, then
position the cursor on cell A1 and Edit | Paste Special | Values
(check) OK then <Esc. You can now delete your helper column.

Hope this helps.

Pete