Finding and Pulling Text Mid String

[tdoolittle13]

Hey guys, I promised I searched around these forums for quite some time before posting, so sorry if this was repeated somewhere.

Right now I have a program that is exporting emails from my Outlook to Excel, specifically a 'Subject' and 'Body'. Each goes into its own cell, so the 'Subject' of the email is in 'A#' while the 'Body' is in the corresponding 'B#' cell.

Pretty straightforward so far. Now the body that is being exported is an automatic email with 150-250 characters. Each email is different, different wording, but they all share the same constant where there is a string of text "Shipped By: CARRIER_NAME" and "Tracking No: ##########". Example:

"-----Original Message-----
Sent: Tuesday, March 11, 2014 12:24 AM
Subject: FW: Your order has shipped (######)


-----Original Message-----
Sent: Tuesday, March 11, 2014 4:12 AM
Subject: Your order has shipped (######)

We thought you'd like to know that we completed and shipped your
Multi-Channel Fulfilment Order () to one of your customers:

You can track the status of this order by visiting Seller Central at:
https://

The following items have been shipped by
--------------------------------------------------------------------------
Qty Item
--------------------------------------------------------------------------
Shipped By: CARRIER_NAME Tracking No: 111111111111111
--------------------------------------------------------------------------

As stated on our Web site, there is no weekend service for our Next Day
delivery option (Express Delivery). Therefore, a package that leaves our
fulfilment centre on a Saturday or Sunday does not actually reach the
carrier until Monday morning.
--------------------------------------------------------------------------
Please note: this email was sent from a notification-only address that
cannot accept incoming e-mail. Please do not reply to this message.


----------------------------------------------------------------------------
--
----------------------------------------------------------------------------
--"

What I need is to pull out the CARRIER_NAME and TRACKING NO into their own cells. Now, the carrier name will usually be one of four different carriers so they all have different character lengths. While tracking ranges drastically in which it may be alphanumeric or simply numeric. I've been playing around with "=MID" and "FIND" functions, but I'm striking out hard. If any one has any suggestions, it would be much appreciated!

[Izandol]

You may try:
C2: =SEARCH("Shipped By:",B2)+11
D2:=SEARCH("Tracking No:",B2,C2)
E2: =TRIM(MID(B2,C2,D2-C2))
F2: =TRIM(MID(B2,D2+13,SEARCH("-",B2,D2)-D2-13))

[tdoolittle13]

Fantastic! Totally worked

What exactly is taking place here, I guess I'm lacking in knowledge much more than I thought?

[Izandol]

C2 finds position of "Shipped By:" in B2 (and adds 11 which is length of this text)
D2 finds position of "Tracking No:" after match in C2
E2 finds text in between these positions (TRIM will remove any extra spaces)
F2 takes text after D2 position up to first "-" character.

Is clear now?