On 9 May 2007 05:52:33 -0700, wrote:

I have a set of alphanumeric data. How do I add just numbers, leaving
letters behind?

For instance, 1X+2X+3X should = 6. Any suggestions?

Thanks!

If you're strings might be more complicated than what you've posted, you could
download and install Longre's free morefunc.xll add-in from
http://xcell05.free.fr/

Then use this formula:

=EVAL(REGEX.SUBSTITUTE(A1,"[A-Za-z]"))


--ron