Extract text in between numbers

[cus701]

Hi,

I have a list of data that contains numbers and text all in one cell and need to extract the text only as per examples below: am trying to automatically extract text in between numbers as per example below:

04-12-2016 13:03:33 50615512 35699217788Test misrah04-12-2016 13:04:04 50616000 35699217788 from this data I need to extract "Test misrah" 06-12-2016 12:03:34 50615512 35698132589a from this data I need to extract "a" 06-12-2016 12:05:06 50615512 35699961001TEST from this data I need to extract "TEST" All data is in the same coloumn. Any help please? Thanks. Malcolm <tbody> </tbody>

<tbody>
</tbody>

 

[Tetra201]

Try this:

=LEFT(MID(A1,41,255),MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},MID(A1,41,255)&"0123456789"))-1)

 

[cus701]

Try this:

=LEFT(MID(A1,41,255),MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},MID(A1,41,255)&"0123456789"))-1)

Thank you very much works perfectly.

Well done.

Malcolm

 

[Tetra201]

You are welcome.