First and foremost thank you for taking a look at this post. Any help will
be greatly appreciated. I am a novice Excel user trying to learn more about
it and am experimenting with statements and formulas and I have run into a
snag for which I can't get around.

In the following working formula =IF(ISERROR(MID('Raw Data'!A1,FIND(" ",'Raw
Data'!A1)+4,100))," ",MID('Raw Data'!A1,FIND(" ",'Raw Data'!A1)+4,100)) I get
a result of "THIS IS A TEST OF THE EMERGNECY BROADCAST SYSTEM 8PM.P3.IF THIS
WERE AN ACTUAL EMERGENCY ........" for example.

What I am trying to do is add to this formula so I get ""THIS IS A TEST OF
THE EMERGNECY BROADCAST SYSTEM" only . In the text that follows "SYSTEM" the
only value that does not change and will always stay the same is "P3" which I
figure I can use to base my find function only and reemove all characters to
the right of P3 and also 4 characters to the left of P3 and lastly removing
the P3 itself. I have tried combination of TRIM and LEN and hve had no luck.
This is a little over my head!

Thanks once again for looking at this post and providing any help you may be
able to offer.