+ Reply to Thread
Results 1 to 5 of 5

copy cell value (here text) to a predetermined number of cells,

  1. #1
    Registered User
    Join Date
    03-15-2012
    Location
    Amsterdam
    MS-Off Ver
    Excel 2010
    Posts
    2

    copy cell value (here text) to a predetermined number of cells,

    Hi there,

    Tried to figure the following out. How to copy a cell value to a predetermined number of cells I would like to create a formula that can handle this problem. e.g.

    example 2 example example

    trythis 3 trythis trythis trythis

    Thanks!
    Thomas

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    47,730

    Re: copy cell value (here text) to a predetermined number of cells,

    In row 2, cell C2: =IF(COLUMN()-2>$B2,"",$A2) ... and drag across as far as you need


    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    25,401

    Re: copy cell value (here text) to a predetermined number of cells,

    With the word example in A1 and 2 in B1, you can put this formula in C1:

    =IF(COLUMN()-2>$B1,"",$A1)

    and copy it across as far as you need to.

    Hope this helps.

    Pete

  4. #4
    Registered User
    Join Date
    03-15-2012
    Location
    Amsterdam
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: copy cell value (here text) to a predetermined number of cells,

    Thanks! It works! Is it also possible to calculate the number of cells automatically instead of dragging it manually?

    Thanks!
    Thomas
    Last edited by Amsterdam; 03-16-2012 at 04:00 PM.

  5. #5
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    47,730

    Re: copy cell value (here text) to a predetermined number of cells,

    No, you have to put the formula in the cells. However, it will put a blank in the cell if the count is exceeded.

    So, just copy it to a large number of columns.

    Regards, TMS

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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