When I have 'Germany' in such cell I want a formula that transforms it into
"GERVar" that is range of cells. When another formula (INDEX formula) goes to
that cell, it would see the content of that cell as "GERVar"=Range of cells
and not text only.

Can you help?

Anne de Courreges