+ Reply to Thread
Results 1 to 2 of 2

convert cell with string formula to be used as a normal fomula

Hybrid View

  1. #1
    Registered User
    Join Date
    03-24-2021
    Location
    singapore
    MS-Off Ver
    365
    Posts
    4

    convert cell with string formula to be used as a normal fomula

    In cell E22 is a string formula, what i want to do is to reference cell E22 to be used in another formula. How do i convert this string formula to be used in another formula?
    Attached Images Attached Images

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,416

    Re: convert cell with string formula to be used as a normal fomula

    With O365, you can use LET... but you probably need to $ the formula in E22.

    A sample sheet, showing what you really want... instead of a non-editable picture that tells us.... ummm... nothing.. would also be useful.
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU

+ 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. Copying fomula down except I want to use formula to left of cell
    By FZ1 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-15-2018, 05:34 PM
  2. [SOLVED] convert a percentage cell to a normal number in another cell
    By tlacloche in forum Excel General
    Replies: 4
    Last Post: 09-26-2013, 09:28 PM
  3. [SOLVED] Formula to convert string in a cell to a date
    By maryren in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-20-2013, 12:08 PM
  4. Need Formula/VBA Code to convert date in String Format to Normal Date format
    By Karthik Sen in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-18-2012, 04:54 AM
  5. Convert string into a cell reference in a formula
    By seaottr in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-03-2011, 07:10 PM
  6. Replies: 1
    Last Post: 06-15-2009, 11:28 PM
  7. Convert Normal formula to array formula
    By Pradip Jain in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-23-2005, 12:06 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