extract only text

[piresmdb]

Im trying to extract only tthe text from the cels that also have numbers like the example below
<TABLE style="WIDTH: 192pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=256 border=0><COLGROUP><COL style="WIDTH: 48pt" span=4 width=64><TBODY><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 192pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent; mso-ignore: colspan" width=256 colSpan=4 height=21>Profit before tax 6,065 4,585 5,136
I want only Profit before tax
any suggestion?
</TD></TR></TBODY></TABLE>

 

[Jonmo1]

Will there only be numbers after the text, or can there be more text AFTER the numbers?

Ie...

Profit before tax 6,065 4,585 5,136 and more text here

 

[Jonmo1]

This will get the text prior to the first number.
It will ignore any text AFTER the first number.

=TRIM(LEFT(A1,MIN(FIND({1,2,3,4,5,6,7,8,9,0},A1&"1234567890"))-1))

 

[Peter_SSs]

If the text is always on the left of the numbers, try

=TRIM(LEFT(A1,MIN(FIND(0,SUBSTITUTE(A1,{1,2,3,4,5,6,7,8,9},0)&0))-1))

Otherwise, please give a more varied set of data and expected results.

 

[piresmdb]

thank you both

there is no more text after the numbers
thank you

Pires