How to find separate text and numbers from an alphanumeric text.

[AKHILESH GUPTA]

How to separate text and numbers from an alphanumeric text with the help of excel formula like
fjdsfjk94289fjk38 fjdsfjkfjk 9428938

 

[shrivallabha]

Welcome to Chandoo.org forums. You should use search facility before posting. Read the forum guidelines once.

A thread with similar requirements is going on:
http://chandoo.org/forum/threads/excel-formula-needed.20287/

Please see if it helps you.