+ Reply to Thread
Results 1 to 4 of 4

Copy the cell content as text and not as formula value

  1. #1
    Registered User
    Join Date
    10-15-2017
    Location
    kanata, ontario, canada
    MS-Off Ver
    MS 365
    Posts
    37

    Copy the cell content as text and not as formula value

    Hi

    Thank you in advance for your help

    I'm creating a timesheet and want to give the ability to the employee to copy and paste the filename suggested.

    So, by using starting date and their name, i've created a formula that suggest the filename as this:

    Timesheeet - Firstname Lastname - StartDate - EndDate

    When i copy and paste this line, it paste the formula info,
    ex: =CONCAT("Timesheet - ",D3," - ",TEXT(B3,"YYYY-MM-DD")," - ",TEXT(B3+13,"YYYY-MM-DD"),".xlsx")

    What I want is:
    Timesheet - Firstname Lastname - 2024-01-14 - 2024-01-27.xlsx

    How do I get this?

    I've attached the spreadsheet that I'm using.

    Thank you

    Maurice
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,422

    Re: Copy the cell content as text and not as formula value

    If you Copy/Paste VALUES then you will get the result you require.
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

  3. #3
    Registered User
    Join Date
    10-15-2017
    Location
    kanata, ontario, canada
    MS-Off Ver
    MS 365
    Posts
    37

    Re: Copy the cell content as text and not as formula value

    Thanks John.

    I think I need a stronger coffee

    Maurice

  4. #4
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,422

    Re: Copy the cell content as text and not as formula value

    You're welcome.

+ 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. VB Code to copy content of cell into Text file
    By rizmomin in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-16-2016, 10:16 PM
  2. Auto-copy cells with specific text-content in cell below
    By jandekeersmaecker in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-28-2013, 12:52 PM
  3. Copy text ONLY Cell Content on Arrow key select
    By Rabbitstew in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-20-2012, 05:19 PM
  4. Copy Cell Text Only Content on single Click
    By Rabbitstew in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 04-20-2012, 01:48 PM
  5. How can I keep the format of cell content when I copy it to text b
    By Garfieldkat in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-09-2005, 06:05 AM
  6. How can I copy cell content to a text box?
    By Garfieldkat in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-08-2005, 10:05 PM

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