Results 1 to 5 of 5

Is there anyway to do the reverse of =FORMULATEXT?

Threaded View

  1. #4
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,710

    Re: Is there anyway to do the reverse of =FORMULATEXT?

    Try this UDF . It works.
    UDF code
    Function ConToFormula(Ip As String)
    ConToFormula = Evaluate(Replace(Ip, """", ""))
    End Function
    How to Use UDF code:
    In the developer tab click--> Visual Basic
    VB window opens
    Insert--> Module
    Paste the code.
    Close the VB window.
    Now UDF is available in Function List
    Save file as .xlsm
    Attached Files Attached Files
    Last edited by kvsrinivasamurthy; 03-08-2022 at 01:31 AM.
    Pl note
    Array formula should be confirmed with Ctrl+Shift+Enter keys together.
    If answere is satisfactory press * to add reputation.

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: 03-08-2022, 05:01 AM
  2. [SOLVED] FORMULATEXT Function Equivalent for 2007
    By TheMechEngineer in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 06-23-2020, 05:20 PM
  3. Using worksheet FORMULATEXT function in VBA
    By RobinClay in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-31-2019, 02:32 PM
  4. [SOLVED] VBA problem - reverse an alphanumeric string, but reverse only letters and leave digits wh
    By mati_WAR in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-18-2019, 10:39 PM
  5. Replies: 7
    Last Post: 11-27-2018, 08:02 PM
  6. [SOLVED] Circular Reference with HYPERLINK and FORMULATEXT: why?
    By Requin in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-17-2017, 11:07 AM
  7. ?Offset and formulatext functions?
    By atung in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 09-19-2016, 01:03 PM

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