I will leave famous footballer in state of confusion (4)
I believe the answer is:
mess
'state of confusion' is the definition.
(I've seen this before)
'i will leave famous footballer' is the wordplay.
I cannot really see how this works, but
'i' could be 'me' and 'me' is found in the answer.
This may be the basis of the clue (or it may be nonsense).
'in' acts as a link.
Can you help me to learn more?
(Other definitions for mess that I've seen before include "Canteen - chaos" , "Service dining-area" , "Where military personnel eat" , "Untidy confusion" , "Where soldiers may eat" .)