I want to extract the numerical part of this formula, so I can work with it in another cell:

=8464184.94*$S35

The formula is in R35.

I did see the post in Is it possible to extract part of a formula in excel? but despite what is said there, there is no such function as EVALUATE() in standard Excel (in my Case Excel 2021 *DESKTOP*).

```
=RIGHT(LEFT(FORMULATEXT(R35),(FIND("*",FORMULATEXT(R35),1)-1)),LEN(LEFT(FORMULATEXT(R35),(FIND("*",FORMULATEXT(R35),1)-1)))-1)
```

works but is, as you can see, pretty ghastly.

`=TEXTAFTER(TEXTBEFORE(FORMULATEXT(R35),"*"),"=")`

don't think this needs the`Evaluate()`

feature of Excel which uses`Excel Macro 4.0`

functions`=LET(a, FORMULATEXT(R35),TRIM(LEFT(SUBSTITUTE(RIGHT(a,LEN(a)-1),"*",REPT(" ",100)),100)))`

`=R35/$S35`

3more comments