+ Reply to Thread
Results 1 to 4 of 4

Paste text of formula

  1. 08-14-2017, 09:49 AM #1
    namuh2
    namuh2 is offline
    Registered User
    Join Date
    08-08-2017
    Location
    Kentucky
    MS-Off Ver
    professional plus 2010
    Posts
    3

    Paste text of formula

    How can you paste the text value of a formula into a cell?
    =INDEX(A1:C5, 2, 3)
    Reply With QuoteRegister To Reply
  2. 08-14-2017, 09:59 AM #2
    TMS
    TMS is offline
    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
    44,364

    Re: Paste text of formula

    Copy the cell and the use Paste Special | Values
    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

    Reply With QuoteRegister To Reply
  3. 08-14-2017, 10:15 AM #3
    namuh2
    namuh2 is offline
    Registered User
    Join Date
    08-08-2017
    Location
    Kentucky
    MS-Off Ver
    professional plus 2010
    Posts
    3

    Re: Paste text of formula

    My Paste Special looks different these days. When I select Paste special, a box opens and I have 3 options:
    HTML
    Unicode Text
    Text

    Neither of these does the trick.
    Reply With QuoteRegister To Reply
  4. 08-14-2017, 01:03 PM #4
    TMS
    TMS is offline
    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
    44,364

    Re: Paste text of formula

    Have you installed any new software? Do you run any macros? When did it change? Is it just one workbook, r all?
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Need Copy/Paste then add text and formula
    By tuongtu3 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-21-2013, 07:51 PM
  2. Paste in a formula instead of text
    By SKiraly in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-26-2011, 06:22 AM
  3. [SOLVED] Help Creating A Formula To Cut and Paste Text
    By Mary in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-07-2006, 02:10 AM
  4. Help Creating A Formula To Cut and Paste Text
    By Mary in forum Excel General
    Replies: 3
    Last Post: 08-06-2006, 09:50 PM
  5. How can I copy and paste the text of a formula?
    By Duke Carey in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-06-2005, 09:05 PM
  6. [SOLVED] How can I copy and paste the text of a formula?
    By Jeff in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 PM
  7. How can I copy and paste the text of a formula?
    By Duke Carey in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-06-2005, 05:05 AM
  8. [SOLVED] How can I copy and paste the text of a formula?
    By Jeff in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1