On Sat, 3 Sep 2005 03:02:03 -0500, Krishnakumar
wrote:


Assuming there can only be a maximum of one letter, and it will be at
the end,

Another option..

For Letter,

In B1

=REPLACE(A1,1,LEN(A1)-1,"")

For Number,

=--SUBSTITUTE(A1,B1,"")

HTH

Doesn't work if there is no letter.


--ron