On Dec 1, 1:29*pm, isabelle wrote:
hi Willie,

=MID(A1,SEARCH("is",A1)+3,SEARCH(", change",A1)-SEARCH("is",A1)-3)
Isabelle,

Thanks for your help. This got me going but I still have an Error for
the POCs since they are not in a uniform order.

The first column works great using:
=MID($A1,SEARCH("When",$A1)+5,SEARCH(" is",$A1)-SEARCH("When",$A1)-5)
And produces the following:
Assigned Organization
Assigned Department
Assigned Group
Assigned Staff

The second column works with:
=MID($A1,SEARCH("is",$A1)+3,SEARCH(", change",$A1)-SEARCH("is",$A1)-3)
Produces:
XYZ
X-A/7
X-B (XMO/ABC)
Staffing Personnel (SP)

The POCs are causing me pain. I’m using:
=MID($A1,SEARCH("Assigned POC",$A1)+15,SEARCH(", change Assigned Alt.",
$A1)-SEARCH("Assigned POC",$A1)-15)
Which works ok for the first three but produces an error for the 4th.
The diff POCs can be anywhere in the string...
Black, Jack
Young, Jim
Simon, Paul
#VALUE!

For “Assigned POC” I really need the 2nd string of “,change” for my
2nd Search. Or the second "," to the RIGHT of the first SEARCH for
“Assigned POC”

Thanks again for your help.

--
isabelle