It appears from the posts that the numbers may
occur before or after the text.

That formula is not durable against trailing numbers
.....it returns the entire source string.

(Plus, I have this "thing" about avoiding array formulas
unless they're absolutely necessary. Seems like nobody I
work with ever remembers to C+S+E them.)
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

"Rick Rothstein (MVP - VB)" wrote in
message ...
if starts with numeric and ends with alpha for example 123MLN, then how?
please suggest for this also

Give this array-entered formula a try...

=MID(A1,MIN(SEARCH(CHAR(64+ROW($1:26)),A1&"abcdefg hijklmnopqrstuvwxyz")),255)

NOTE: Commit this formula by pressing Ctrl+Shift+Enter instead of just
Enter.

Rick