+ Reply to Thread
Results 1 to 2 of 2

How to copy and paste data into middle of other cell without overwriting?

  1. #1
    Registered User
    Join Date
    09-22-2014
    Location
    Niagara
    MS-Off Ver
    Excel 2002
    Posts
    1

    How to copy and paste data into middle of other cell without overwriting?

    I have 2 columns and want to copy the one rows data into a certain spot in other cell.

    For example row 1 has
    8766
    7446
    6633

    Row 2 has a link to images I need so
    Www.example.com/images/item(need to paste to here).jpg

    I need to copy and paste the row of numbers to item(blank).jpg.

    Not sure if that makes sense. I have 29,000 images and don't want to type each link manually

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: How to copy and paste data into middle of other cell without overwriting?

    That is a simple formula I think.
    in A3 type:

    =left(A2,len(A2)-4) & A1 & ".jpg"

    fill to the right.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 09-03-2014, 12:46 AM
  2. Copy up to blank cell, transpose, and insert rows without overwriting data below
    By scooter7 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-10-2013, 10:48 PM
  3. Copy Cell Data from one sheet to another without overwriting
    By gw73 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-29-2009, 07:24 AM
  4. copy and paste without overwriting cells containing values
    By schueyisking in forum Excel General
    Replies: 2
    Last Post: 08-14-2008, 05:43 AM
  5. copy and paste without overwriting cells containing values
    By schueyisking in forum Excel General
    Replies: 1
    Last Post: 08-14-2008, 12:26 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1