Split Cells using a Function

M

Morpheus2067

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
 
G

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.
 
Top