<div>
you probably need to write a macro function to evaluate it<br><br><pre><code class="code-1 nolinks" id="code-20-43084913-1"><span>Function ev(r As Range) As Variant</span>
<span>&nbsp; &nbsp; &nbsp; ev = Evaluate(r.Value)</span>
<span>End Function</span>
</code></pre>to apply:<br><br><pre><code class="code-1 nolinks" id="code-20-43084913-2"><span>=ev(C2)</span>
</code></pre>Excel function that evaluates a string as if it were a formula?<br><a href="https://superuser.com/questions/253353/excel-function-that-evaluates-a-string-as-if-it-were-a-formula" rel="ugc">https://superuser.com/questions/253353/excel-function-that-evaluates-a-string-as-if-it-were-a-formula</a><br><br><a href="https://filedb.experts-exchange.com/incoming/2020/05_w20/1455641/Concatenate_Formula_b.xlsm" rel="ugc">Concatenate_Formula_b.xlsm</a>
</div>


Concatenate_Formula_b.xlsm

EE-29181898-Concatenate_Formula-Ver.xlsx

Consultant

Star Gazr1

<div>
The old Excel 4 macro language had a function called EVALUATE which would do exactly what you want. Although that language has been functionally obsolete since Excel 5 and VBA were released in 1993, it still works.<br><br>I suggest setting up a named formula using EVALUATE. To do so:<ol><li>Select cell D2 in your sample workbook</li><li>Open the Formulas...Name Manager menu item</li><li>Create a new name for the Name field. I called mine Evaluator. Then in the Refers to field enter this formula and click OK.</li></ol>=EVALUATE(C2)<br><br>&nbsp; 4. You may then use a worksheet formula in cell D2 and copy it down to get your answers:<br>=Evaluator<br><br>Note that the parameter being evaluated is passed by its relative position to the cell with the formula. By selecting cell D2 when I created the named formula and then using cell C2 in the Refers to field, Excel knows that the parameter will be coming from the cell to the left of the one with the formula =Evaluator.
</div>


Concatenate_Formula.xlsx

<div>
One thing I forgot to mention: you must save the file as .xlsm to preserve your named formula. You must also enable macros when you open the file.<br><a href="https://filedb.experts-exchange.com/incoming/2020/05_w20/1455649/Concatenate_Formula.xlsm" rel="ugc">Concatenate_Formula.xlsm</a><br><br>
</div>


Concatenate_Formula.xlsm

<div>
Because the named formula isn't passed any parameters directly, it won't update when you change the expression in the cell to its left. You need to select the cell containing =Evaluator, then click in the formula bar and hit Enter to make it re-evaluate.<br><br>&nbsp;The SuperUser link in @Ryan Chong's answer shows a nice trick for making the named formula volatile. In so doing, it recalculates every time the user changes the value in any cell. The trick is to change the Refers to formula in the Name Manager to something like:<br>=IF(TODAY(),EVALUATE(C2))<br><br>TODAY returns a positive number, so the IF always returns its TRUE option. And because TODAY is volatile, any formula using it will be volatile--which is exactly what we need.
</div>


<div>
thanks very much for the help I really appreciate it. I should have mentioned I can't use a macro. I am restricted from running macros. &nbsp;I did get some help with another option using: =LEFT(C1,FIND("/",C1)-1)/(RIGHT(C1,LEN(C1)-FIND("/",C1)))<br>I was hoping if I there might be other methods as I have to do a lot of different calculations with a very large spreadsheet so that is why I posted here. &nbsp;
</div>


<div>
It's not clear, to me at least, why you need to do it that way.<br />
<br />
The example I posted above seems to solve the problem, but I assume not?<br />
<br />
What about that approach does not work?<br />
<br />
Thanks,<br />
<br />
Alan.
</div>


<div>
If you were sitting in the cubicle next to mine, I'd challenge your statement "I am restricted from running macros." Who is doing the restricting, and why? If I got any sense that it was a pointy-haired boss who had no clue how difficult he was making your job, I'd go right into his office and explain the facts of life to him. The two good solutions to your problem are either to avoid trying to evaluate text expressions or to use code to do it.<br><br>There is no "formula only" solution to the general problem of evaluating a text expression without using either Excel 4 macros, VBA macros or Office-js macros. There may, however, be formula only solutions to problems where the text expression falls into one of a small number of different patterns.<br><br>If you want to perform the calculations without using a macro, you need to define the full extent of variability in your expressions to be calculated. When you post a workbook with sample data, don't show 26 variations on the exact same structure. Instead, show one each of all the different types of expressions that might be encountered. Among the considerations:<ol><li>What are the possible operators (+, -, /, *, ^)?</li><li>Are there any functions (sine, log, etc.)?</li><li>What is the maximum number of operators in an expression?</li><li>Might the numbers in the expressions use decimal points or commas?</li><li>Might parentheses or square brackets be used?</li></ol><br>The simpler the problem definition, the more likely it is that somebody will build a formula for you. If the problem can be set up so the expression is already parsed, that would make evaluating the expression easier. Parsed means the expression is built from several cells, each of which contains either a number or an operator. Your sample problem would therefore need five cells, three for numbers and two for operators.
</div>


<div>
<div class="content wysiwyg-content">
in Excel 2019, &nbsp;I am trying to apply a calculation to a concatenated column. &nbsp;Attached is a sample spreadsheet. I am also attaching a screenshot as a reference to the info below. Column A and B has the values. Column C is concatenatenation of Column A and Column B Values <br />
In Column D, I am trying to see if there is a method to reference the data in Column C and have it become a calculation.<br />
Column E shows how to do this manually with a formula. I am working with a lot of information and the values change in column A and Column B, so that is why the way I set this up with the concatenation is going to be the easiest way to update, unless there is another method i haven't thought of. <br />
Any info is appreciated. &nbsp;Thanks very much.<a href="https://filedb.experts-exchange.com/incoming/2020/05_w20/1455635/Concat_formula2.JPG" target="_blank" title="Screenshot (50 KB)"><img alt="Screenshot" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2020/05_w20/800_1455635/Concat_formula2.JPG" /></a><a href="https://filedb.experts-exchange.com/incoming/2020/05_w20/1455634/Concatenate_Formula.xlsx" target="_blank" class="file-inline" title="Concatenation Spreadsheet (10 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>Concatenate_Formula.xlsx</a>
</div>
</div>


Concat_formula2.JPG

in Excel 2019,  I am trying to apply a calculation to a concatenated column.  Attached is a sample spreadsheet. I am also attaching a screenshot as a reference to the info below. Column A and B has the values. Column C is concatenatenation of Column A and Column B Values 
In Column D, I am trying to see if there is a method to reference the data in Column C and have it become a calculation.
Column E shows how to do this manually with a formula. I am working with a lot of information and the values change in column A and Column B, so that is why the way I set this up with the concatenation is going to be the easiest way to update, unless there is another method i haven't thought of. 
Any info is appreciated.  Thanks very much.

Excel Concatenation Formula

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.