I would like a UDF that removed text from cell contents and gave the result for the remaining numbers, etc. For example:
Cell A2 contains: 0.25*Pi*[Dia =](1.5^2)*[h]2
I would like the UDF to remove all instances of [......]
And in Cell B2 enter UDF(A2) and get the result 3.53 (ie, the volume).
This would allow me to keep a record in the cell of what the figures represent.
Help appreciated.
DesM