separate text from number

[Jay Phang]

Below are text and number within a column what should do to separate them.

Thanks

AH TAU 94998527
GINA TAN 81119438
PATRICK LIM 85225633
SHARON LEE 98570327
BEN THAI 0162311334
JANE TAN THAI 6614315030
C Y LOW 90821189
TONY TRIEU 92283242 /82672698

 

[Jay Phang]

Please help. thanks

 

[Rick Rothstein]

Some questions...

1. Are your numbers always locate at the end of the text as your examples show?

2. Is there always a space character in front of your number?

3. Show us what you want from that last example.

 

[anandvarma]

try this

Excel Workbook
	A	B
1	AH TAU 94998527	94998527
2	GINA TAN 81119438	81119438
3	PATRICK LIM 85225633	85225633
4	SHARON LEE 98570327	98570327
5	BEN THAI 0162311334	0162311334
6	JANE TAN THAI 6614315030	6614315030
7	C Y LOW 90821189	90821189
8	TONY TRIEU 92283242 /82672698	92283242 /82672698
Sheet1

 

[anandvarma]

try this also

Excel Workbook
	A	B	C
1	original text	Number in the text	Text
2	AH TAU 94998527	94998527	AH TAU
3	GINA TAN 81119438	81119438	GINA TAN
4	PATRICK LIM 85225633	85225633	PATRICK LIM
5	SHARON LEE 98570327	98570327	SHARON LEE
6	BEN THAI 0162311334	0162311334	BEN THAI
7	JANE TAN THAI 6614315030	6614315030	JANE TAN THAI
8	C Y LOW 90821189	90821189	C Y LOW
9	TONY TRIEU 92283242 /82672698	92283242 /82672698	TONY TRIEU
Sheet1

 

[Rick Rothstein]

Okay, assuming your numbers are always at the end of the text and that you can both sets of numbers (including the slash mark in the middle) from that last example, then give this formula a try...

=MID(A1,MIN(FIND({0,1,2,3,4,5,6,7,8,9},A1&"0123456789")),999)