How can i separate alphabates and numerics in a cell ??

[Shyam Gupta]

Input Required Output
12ra6j9a87n05 12698705 rajan
s2u615un85n000y12 26158500012
suunny

How can i separate alphabates and numerics in a cell ??

 

[bobhc]

You have asked this question here.

http://chandoo.org/forum/threads/need-to-separate-alphabets-and-numbers.22073/

By re-posting the same question you are shoving others down the list, this is know as bumping and is bad forum manners, try doing a little forum work on your own and you will find more answers than you need.



.