Thread
:
How in to parse constants in formula to cells
View Single Post
#
8
Posted to microsoft.public.excel.programming
Ron Rosenfeld
external usenet poster
Posts: 5,651
How in to parse constants in formula to cells
On Sat, 25 Nov 2006 16:11:13 GMT,
wrote:
Appreciate your time & knowledge. I agree, the challenge is awesome.
EagleOne
If I were going to do that, I think I would first replace every character that
is a function parameter with a nonsense string, perhaps a tilde ~.
Then replace all the cell references and operators with tilde's.
Then extract the numbers that remain.
I would use regular expressions to do all that.
--ron
Reply With Quote
Ron Rosenfeld
View Public Profile
Find all posts by Ron Rosenfeld