What are the morons doing?

--

HTH

Bob

"pat67" wrote in message
...
On Apr 30, 10:42 am, "Bob Phillips"
wrote:
Try

=MID(A2,FIND("QN ",A2),14)

and copy down

--

HTH

Bob

"pat67" wrote in message

...



I have a sheet that i downloaded from our erp system that has one
column with text. the text is long and descriptive. the only thing is
the same is that there is one piece that starts with QN then a blank
then 11 numbers like this. QN 40000152489. What i want to do is pull
that from the text cell to another cell. Is that possible?- Hide quoted
text -

- Show quoted text -

this works. almost always. It would all the time but i am dealing with
morons.

Thanks