Find specific text within text and result dependent text in specified column

Hi all,

I am dealing with the following issue,

I get data for email categorization in format like :

'text1;text2;text3'
(it is possible to have missing values within the text)

I attach a sample in order to expain.

The text in column A provides me the information regarding the sender of the email (Column FROM), the action (Column ACTION/INFO) and the subject (Column SUBJECT). So from the column A I want the text to split in the 3 columns B - C - D.

The problem is that I cannot use text to columns since the texts within each cell are not always in the right order.

So I made 3 tables (columns G:H, I:J & K:L) in order to show you the texts I may find within the text 'text1;text2;text3' of column A and the result I want in columns B - C - D.

For example:

If I have the following text in column A:

AGREEMENTS; ACTION; DEALER

then I want the result to be :

in column B 'DEALER',
in column C 'ACTION'
in column D 'AGREEMENTS'


Any help will be highly appreciated!