Okay, in that case, something like this which effectively says for each name question:
Code:
{if(substr(A41,1,0) == 'V', 'she', if(substr(A41,1,0) == 'M', 'he', ''))}
{if(substr(A42,1,0) == 'V', 'she', if(substr(A42,1,0) == 'M', 'he', ''))}
{if(substr(A43,1,0) == 'V', 'she', if(substr(A43,1,0) == 'M', 'he', ''))}
{if(substr(A44,1,0) == 'V', 'she', if(substr(A44,1,0) == 'M', 'he', ''))}