+ Reply to Thread
Results 1 to 4 of 4

copy 2 times to one cell

  1. #1
    Registered User
    Join Date
    02-11-2016
    Location
    Wisconsin
    MS-Off Ver
    07-360
    Posts
    53

    copy 2 times to one cell

    Hi, As the title says, I am trying to copy 2 times into one cell. I have tried several things to get this to work and searched online to no avail.
    I would like the times to appear as time 1 above time 2 in the same cell.
    Please Login or Register  to view this content.
    What I have tried is:
    Please Login or Register  to view this content.
    Which shows the time value not in the short format I am looking for

    Please Login or Register  to view this content.
    Which Reads "False" for both times

    If I comment out one time, I can get it to work with the other. I am trying to create a report and really need both in one cell. Any ideas? Also, I am not concerned if only 1 time shows when both are the same. Thanks!

  2. #2
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: copy 2 times to one cell

    Maybe:

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    02-11-2016
    Location
    Wisconsin
    MS-Off Ver
    07-360
    Posts
    53

    Re: copy 2 times to one cell

    Thanks for the fast reply! Worked great, thanks!

  4. #4
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: copy 2 times to one cell

    You're welcome. Glad to help out and thanks for the feedback.

+ 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. Copy Cell Values in two Columns down x number of times then jump and copy some more.
    By scholly23 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-02-2014, 03:19 AM
  2. How to Copy Cell Value for x number of times
    By stfrancis in forum Excel General
    Replies: 21
    Last Post: 12-11-2013, 04:22 AM
  3. copy a cell multiple times depending on cell value starting on a specific cell
    By weritadiojomiel in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-17-2013, 05:25 AM
  4. [SOLVED] If cell is GT 1, copy row x-1 times and update each new row.
    By LarryDH in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-06-2012, 04:16 PM
  5. Excel 2007 : A way to copy a cell X amount of times
    By duffy1807 in forum Excel General
    Replies: 2
    Last Post: 10-02-2011, 06:29 PM
  6. Copy cell to another sheet 15 times
    By polomontreal in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-08-2011, 11:33 AM
  7. Copy every n cell and paste n-times
    By Kanja13 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-09-2010, 05:00 AM

Tags for this Thread

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