Column A has data e.g. cat is fat xy>zzy, dog is random xyzzy, rat is a hoax.set xyz, frog is alon.23e xyz, bullseye.8 x.z
I have a look up table as below
Col D
xy>zzy
xyz
x.z
(Note: the values in Col D do not have a set number of characters, so I cant use a Right/left Formula)
I need...