srizki
Well-known Member
- Joined
- Jan 14, 2003
- Messages
- 1,844
- Office Version
- 365
- Platform
- Windows
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>
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>