Split Cells using a Function

[Guest]

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

 

[Guest]

Hi
It depends on what other entries you have in your series. For the ones shown
you could just use
=LEFT(A2,1)
but that might not fit for all of the possibilities.

Andy.