need to extract piece of string

So I have a similar issue that I am trying to resolve. I have several cells (rows 2-*) that contain data like shown below;

"Ad Size = 160x600","Make = JEEP","Search Type = All","Search Type = New","Search Type = Used"

"Ad Size = 160x600","Model = Grand Cherokee","Make = JEEP","Search Type = All","Search Type = New","Search Type = Used"

As you can see the strings are not particularly in any order so text to columns winds up further messing up the data. What I want to be able to do is create columns(B-E);

Ad Size Make Model Body Style

and if there is a value within the string for any of these to put it in the respective column. The catch, I cannot use left or right because the values can be anywhere in the string. I am running into difficulty using the mid formula because it requires me to specify the length of what I want returned which can vary.

I guess the gist of what I'm looking for is a formula or VBA to scan a string and return the value that corresponds inside that string in another column. I want this to be smart enough to also determine how many characters are located between the "Ad Size = " and the next comma in order to return the entirety of the results.

In cells B1:E1 enter the headings:

Ad Size ; Make ' Model ; Body Style

In cell B2, enter and copy across and down:

=IF(ISERROR(SEARCH(B$1,$A2)), "" ,MID($A2,SEARCH(B$1,$A2)+LEN(B$1)+3, SEARCH("""", $A2, SEARCH(B$1, $A2))-SEARCH(B$1, $A2)-LEN(B$1)-3))

HTH

Jason