software

here is my text strong:
PO: TransC:MMU - DO NOT BREAKTICKET:ALLOC:RE ORDER OF # 103157131,
101915744. MMU - DO NOT BREAKAP:

I want to return text starting with ALLOC but stop at and not include AP.

thank you in advance, jane

use FIND or SEARCH to find the position of the desired text and then
incorporate into a MID function

--
Don Guillett
SalesAid Software

quot;Janequot; gt; wrote in message
...
gt; here is my text strong:
gt; PO: TransC:MMU - DO NOT BREAKTICKET:ALLOC:RE ORDER OF # 103157131,
gt; 101915744. MMU - DO NOT BREAKAP:
gt;
gt; I want to return text starting with ALLOC but stop at and not include AP.
gt;
gt; thank you in advance, jane

quot;Janequot; gt; wrote in message
...
gt; here is my text strong:
gt; PO: TransC:MMU - DO NOT BREAKTICKET:ALLOC:RE ORDER OF # 103157131,
gt; 101915744. MMU - DO NOT BREAKAP:
gt;
gt; I want to return text starting with ALLOC but stop at and not include AP.
gt;
gt; thank you in advance, jane

=MID(B2,SEARCH(quot;ALLOCquot;,B2,1),SEARCH(quot;AP:quot;,B2,1)-(SEARCH(quot;ALLOCquot;,B2,1)))
=(MID(A1,FIND(quot;ALLOCquot;,A1,1),FIND(quot;AP:quot;,A1,1)-FIND(quot;ALLOCquot;,A1,1)))

and if you want the colon at the end.....

=(MID(A1,FIND(quot;ALLOCquot;,A1,1),FIND(quot;AP:quot;,A1,1)-FIND(quot;ALLOCquot;,A1,1)))amp;quot;:quot;

Vaya con Dios,
Chuck, CABGx3
quot;Janequot; gt; wrote in message
...
gt; here is my text strong:
gt; PO: TransC:MMU - DO NOT BREAKTICKET:ALLOC:RE ORDER OF # 103157131,
gt; 101915744. MMU - DO NOT BREAKAP:
gt;
gt; I want to return text starting with ALLOC but stop at and not include AP.
gt;
gt; thank you in advance, jane
purely as a time issue, ca you show me how that would look?quot;Don Guillettquot; wrote:

gt; use FIND or SEARCH to find the position of the desired text and then
gt; incorporate into a MID function
gt;
gt; --
gt; Don Guillett
gt; SalesAid Software
gt;
gt; quot;Janequot; gt; wrote in message
gt; ...
gt; gt; here is my text strong:
gt; gt; PO: TransC:MMU - DO NOT BREAKTICKET:ALLOC:RE ORDER OF # 103157131,
gt; gt; 101915744. MMU - DO NOT BREAKAP:
gt; gt;
gt; gt; I want to return text starting with ALLOC but stop at and not include AP.
gt; gt;
gt; gt; thank you in advance, jane
gt;
gt;
gt;

I see that you were fed the answer. I wonder if it will stick with you as
long as if you had done it yourself?

--
Don Guillett
SalesAid Software

quot;Janequot; gt; wrote in message
news
gt; purely as a time issue, ca you show me how that would look?
gt;
gt;
gt; quot;Don Guillettquot; wrote:
gt;
gt;gt; use FIND or SEARCH to find the position of the desired text and then
gt;gt; incorporate into a MID function
gt;gt;
gt;gt; --
gt;gt; Don Guillett
gt;gt; SalesAid Software
gt;gt;
gt;gt; quot;Janequot; gt; wrote in message
gt;gt; ...
gt;gt; gt; here is my text strong:
gt;gt; gt; PO: TransC:MMU - DO NOT BREAKTICKET:ALLOC:RE ORDER OF # 103157131,
gt;gt; gt; 101915744. MMU - DO NOT BREAKAP:
gt;gt; gt;
gt;gt; gt; I want to return text starting with ALLOC but stop at and not include
gt;gt; gt; AP.
gt;gt; gt;
gt;gt; gt; thank you in advance, jane
gt;gt;
gt;gt;
gt;gt;
hmmm, tried both but got the #VALUE error. Is that a function of copying
from here to my spreadsheet? Do I need to type our the formula?

quot;CLRquot; wrote:

gt; =(MID(A1,FIND(quot;ALLOCquot;,A1,1),FIND(quot;AP:quot;,A1,1)-FIND(quot;ALLOCquot;,A1,1)))
gt;
gt; and if you want the colon at the end.....
gt;
gt; =(MID(A1,FIND(quot;ALLOCquot;,A1,1),FIND(quot;AP:quot;,A1,1)-FIND(quot;ALLOCquot;,A1,1)))amp;quot;:quot;
gt;
gt; Vaya con Dios,
gt; Chuck, CABGx3
gt;
gt;
gt;
gt; quot;Janequot; gt; wrote in message
gt; ...
gt; gt; here is my text strong:
gt; gt; PO: TransC:MMU - DO NOT BREAKTICKET:ALLOC:RE ORDER OF # 103157131,
gt; gt; 101915744. MMU - DO NOT BREAKAP:
gt; gt;
gt; gt; I want to return text starting with ALLOC but stop at and not include AP.
gt; gt;
gt; gt; thank you in advance, jane
gt;
gt;
gt;

quot;Don Guillettquot; gt; wrote in message
...
gt;I see that you were fed the answer. I wonder if it will stick with you as
gt;long as if you had done it yourself?
gt;
gt; --
gt; Don Guillett

Don,

Of course, your right. Teaching how to fish is better than giving fish away.
I'm here learning Excel, too, and I get excited when I can solve. It's also
very interesting to see how many different solutions and variations come up.
Moderation....

Beege

I'm glad you agree. As time goes on you will find that there are usually
several ways to quot;skin the catquot;

--
Don Guillett
SalesAid Software

quot;Beegequot; gt; wrote in message
...
gt; quot;Don Guillettquot; gt; wrote in message
gt; ...
gt;gt;I see that you were fed the answer. I wonder if it will stick with you as
gt;gt;long as if you had done it yourself?
gt;gt;
gt;gt; --
gt;gt; Don Guillett
gt;
gt; Don,
gt;
gt; Of course, your right. Teaching how to fish is better than giving fish
gt; away. I'm here learning Excel, too, and I get excited when I can solve.
gt; It's also very interesting to see how many different solutions and
gt; variations come up. Moderation....
gt;
gt; Beege
gt;
gt;
gt;
Could be.........these are relatively long formulas and may quot;wrapquot; when
copying and pasting.....you may need to re-type if it don't all copy into one
cell.

Vaya con Dios,
Chuck, CABGx3
quot;Janequot; wrote:

gt; hmmm, tried both but got the #VALUE error. Is that a function of copying
gt; from here to my spreadsheet? Do I need to type our the formula?
gt;
gt; quot;CLRquot; wrote:
gt;
gt; gt; =(MID(A1,FIND(quot;ALLOCquot;,A1,1),FIND(quot;AP:quot;,A1,1)-FIND(quot;ALLOCquot;,A1,1)))
gt; gt;
gt; gt; and if you want the colon at the end.....
gt; gt;
gt; gt; =(MID(A1,FIND(quot;ALLOCquot;,A1,1),FIND(quot;AP:quot;,A1,1)-FIND(quot;ALLOCquot;,A1,1)))amp;quot;:quot;
gt; gt;
gt; gt; Vaya con Dios,
gt; gt; Chuck, CABGx3
gt; gt;
gt; gt;
gt; gt;
gt; gt; quot;Janequot; gt; wrote in message
gt; gt; ...
gt; gt; gt; here is my text strong:
gt; gt; gt; PO: TransC:MMU - DO NOT BREAKTICKET:ALLOC:RE ORDER OF # 103157131,
gt; gt; gt; 101915744. MMU - DO NOT BREAKAP:
gt; gt; gt;
gt; gt; gt; I want to return text starting with ALLOC but stop at and not include AP.
gt; gt; gt;
gt; gt; gt; thank you in advance, jane
gt; gt;
gt; gt;
gt; gt;