Mid, left right extract.

[srizki]

I am using formula =MID(G8,LEFT(32,255),6) OR =MID(G8,32,6) same thing.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
My question is whaat if there are not always 32 characters before the required value, or the value on the right of the is always 5 digit and characters on the left of the value are not the same. <o></o>
So for example. <o></o>
<o> </o>
February 2009 Biomed Charges to 50051-6510<o></o>
I want to extract 50051, so what will be the better formula than the one I am using.<o></o>
<o> </o>
Thanks<o></o>

 

[PCL]

Is the number at the end allways ?????-???? it means 5 digits - 4 digits

 

[srizki]

Yes!

 

[carsten]

you search for the position of text " to ", add the 4 characters of " to " to extract your 5 digit number:

=MID(A1,SEARCH(" to ",A1)+4,5)

unfortunately may not work in all thinkable cases ...

 

[lenze]

Maybe

=MID(G8,FIND("-",G8)-5,5)

lenze

 

[PCL]

Perhaps
Assuming data in cell B3

=MID(B3,LEN(B3)-10+1,5)*1

 

[carsten]

Is the number at the end allways ?????-???? it means 5 digits - 4 digits

then this should work:
=MID(G8,LEN(G8)-9,5)

 

[Osvaldo Palmeiro]

=LEFT(RIGHT(A1,10),5)<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>

 

[srizki]

Thanks to all.

sohail