I have a series of cells in a column that looks like {2X, 1X, 3X...}etc. I
need to split the number from the letter, and yet have it flexible, so if I
change a 2X to a 1X, the split updates automatically, which is not what
Text to Columns does. I am using Excel 2003. If there is a formula or
something that does this, I would be greatly appreciative.

Thanks
-Morpheus