Store Formula to variable

[ionelz]

Is this possible ?
Store LEN(A2) to V1, like LEN(A2)=V1 then = MID(A2,V1,V1-1) ?

[jeffreybrown]

Not sure without seeing a small sample worksheet with your before and after?

[ionelz]

Example =MID(A2,LEN(A2)-3,5)
I want to store LEN(A2)-3 to v1
Then MID(A2,v1,5)

[jeffreybrown]

Can you post an actual sample in a workbook?

With what you have asked, if you had the word "Geometry" in A2

=LEN(A2)-3 returns 5

The result of =MID(A2,V1,5) is "etry"

[MrShorty]

This is posted to Excel General, so I am not sure what your desired context or constraints are.

In a very basic sense, if we see V1 as a cell reference (to V1), then one could store the formula =LEN(A2)-3 in V1, then your other cells/formulas can refer to the cell V1 whenever you want to use that value. This is the "unpopular" helper cell that I like to use so much.

Another strategy that gets talked about is storing a named formula (which is just a more complicated variation of named ranges). http://spreadsheetpage.com/index.php...ng_techniques/ I don't use these at all, preferring to use helper cells, but other people sometimes like these.

As a first guess, I think that one of those two techniques is what you are trying to describe.