I have an application where i would like to iterate through a cell and
separate integers from text values. I want to take the text values and
find out if they are all the same. In addition, I want to ignore the
text value "X"...

For example:

1bb should just return "b" - since it is all b's and numbers.
x2uu should return "u" - it meets the same criteria as above and x
should be ignored.
2 or x2 would return something like "numeric"
2uubb would return something like "multiples"

Does anyone have any ideas if this is possible in Excel? I would
prefer a formula, but a macro would be ok too. Please help. Thanks so
much!


--
joeboe
------------------------------------------------------------------------
joeboe's Profile: http://www.excelforum.com/member.php...o&userid=27900
View this thread: http://www.excelforum.com/showthread...hreadid=474004