Hi Elton,

To do it in a formula without having to write a custom function in
VBA:

With your text in column A:

9j36
12k27
23m13
1°26
1234a1
1a1234
1abc23
12°a°b°c°3

In column B:
=itSEARCH(A1,"[0-9]{1,}",,3)
Results:
9
12
23
1
1234
1
1
12

In column C:
=itSEARCH(A1,"[^0-9]{1,}",,3)
Results:
j
k
m
°
a
a
abc
°a°b°c°

In column D:
=itSEARCH(A1,"[0-9]{1,}",,3,,,,,TRUE)
Results:
36
27
13
26
1
1234
23
3



To get the itSEARCH() function, you'll need to download and install
the Free Edition of inspector text:
(it never expires)
http://precisioncalc.com/it


For more information on the itSEARCH function:
http://precisioncalc.com/it/itSEARCH.html


Good luck with your project!


Greg Lovern
http://PrecisionCalc.com
More Power In Excel





On May 25, 4:11*am, Elton Law
wrote:
Dear Expert,
How to split a cell into 3 parts if they are like this please ?

Befo
9j36 in one cell
After:
9 j 36 in 3 different cells

Befo
10°32 in one cell
10 ° 32 in 3 different cells

Thanks