+ Reply to Thread
Results 1 to 2 of 2

turn concatinated string into formula

  1. #1
    Forum Contributor
    Join Date
    10-09-2012
    Location
    Adelaide, South Australia
    MS-Off Ver
    Excel 2010
    Posts
    135

    turn concatinated string into formula

    Good morning,
    This is one I have wrested with before.

    is there a was (without using VBA) to turn a concatenation into a formula?

    currently my (array) formula looks like this:
    =CONCATENATE("(",ABS(G44),INDEX(Specifications[[Reading % Model 175]:[Counts Model 179]],MATCH(1,(E44&" "&D44=Specifications[Function])*(ABS(G44)>=Specifications[MIN Range])*(ABS(G44)<=Specifications[MAX Range]),0),MATCH("Reading % Model "&ModelMeter,Specifications[[#Headers],[Reading % Model 175]:[Counts Model 179]],0)))

    basically it is concatenating: "(",600,*0.9%)+2 and as text is correctly returning: (600*0.9%)+2
    however I would like to execute this formula, I have tried adding +0 at the end but it doesn't seem to work.

    Can any one help?
    Last edited by wacky_diva; 11-16-2016 at 08:32 PM.

  2. #2
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: turn concatinated string into formula

    Select the cell in question

    CTRL + H (this will open the Edit /Replace userform)

    Find what: (
    Replace with: =(
    Replace All

    The cell will now contain the formula:

    =(600*0.9%)+2
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

+ 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. Turn off calculations before query refresh....turn them back on after
    By mk3ll00 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-30-2014, 03:25 PM
  2. [SOLVED] turn text string into row/s for each specific serial number
    By petrasimonova in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-10-2013, 05:48 AM
  3. Replies: 3
    Last Post: 07-10-2012, 01:49 AM
  4. Auto calc on, then turn off, then runtime error how to turn back on
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 11-22-2011, 10:37 AM
  5. Replies: 1
    Last Post: 07-30-2010, 03:35 PM
  6. [SOLVED] EXCEL - Concatinated Y-axis Label
    By Mancini-Small-Bus in forum Excel General
    Replies: 1
    Last Post: 10-28-2005, 12:05 PM
  7. VLookup with concatinated named range
    By David Gibson in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-26-2005, 05:15 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