Thread: formula to code

I have to use foll formula very often on particular data.
Data:--
TIN NO. 22523300218
TIN NO. 22523300218
B/CST/1490 DT 13/01/99
B/CST/1490 DT 13/01/99
2252335588
457896321V 13/01/12


I use formula to extract nos. from it:
LOOKUP(99^99,--("0"&MID(REPLACE(A1,SEARCH("/??/",A1&"/~~/")-2,10,""),MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},REPLACE(A1&" ",SEARCH("/??/",A1&"/~~/")-2,10,"")&"0123456789")),ROW($1:$80))))

Actually i dnt need A1 because i can use it anywhere in sheet in any workbook.
I think to make user defined function named Extract so that i can use it always i need.
Thanks for help!!!

http://www.mrexcel.com/forum/showthr...=1#post3035999

You can define a name for a complex formula

Go to Insert>Name>Define and in the "Names in workbook" box type: a name for the formula e.g. MyFormula
Now click in the "Refers to" box and type or paste your formula then click Add.

In a cell type =MyFormula

Here's a fuller explanation

I'm sure that the formula will only work in the workbook that holds the Name

Thanks for the rep.

Cross post here.