Find the first letter in a cell
On Mon, 26 Oct 2009 07:51:01 -0700, Jacob Skaria
wrote:
Please note that this is an array formula. You create array formulas in the
same way that you create other formulas, except you press CTRL+SHIFT+ENTER to
enter the formula. If successful in 'Formula Bar' you can notice the curly
braces at both ends like "{=<formula}"
=MID(A1,COUNT(1*MID(A1,ROW($1:$9),1)),1)
If this post helps click Yes
---------------
Jacob Skaria
This seems to fail with certain combinations:
10S11
A143
1A99
--ron
|