complex sorting

Hi, i have an excel of around 8000 lines.


i would like to organise them by column.

column 1, the company name (it's in upper case)
column 2, the first and last name (it's usually just next to the company name on the same line)
column 3, i want the function in the company
column 4, i want the email id

text like: 26/12/2013 à contacter for example,should be deleted

It is very difficult for me to work on. Only an experienced excel guru can help me.
Waiting patiently

see attached file below