suppose u have value in A1

In B1 put this formula to separate number
=MID(A1,MATCH(TRUE,ISNUMBER(1*MID(A1,ROW($1:$20),1 )),
0),COUNT(1*MID(A1,ROW($1:$20),1)))

suppose in your data alphabets comes before the number then use this
to separate the text from numbers.
=MID(A1,ROW($1:$20),LEN(A1)-COUNT(1*MID(A1,ROW($1:$20),1)))

suppose in your data number comes first before the alphabets then use
this separate the text from numbers.
=RIGHT(B2,LEN(B2)-COUNT(1*MID(B2,ROW(1:20),1)))

note : ctrl+shift+enter once u enter the formula.







On Sep 14, 4:28*pm, Tazeem wrote:
How exactly text and numbers can be separated in an unmerged cell. There is
not a fixed number of digits in the available data so 'Text to column' option
does not work. Please help.

Thanks & Regards