Narasimha, if you are still reading this thread, you might find the
alternate solution I posted to Ron of some interest.

Rick


"Narasimha" wrote in message
...
thanks Rick

"Rick Rothstein (MVP - VB)" wrote:

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