[ms office - 2007] Word Field Code Fun

[Stuart_C]

I'm currently messing around with Word filed codes in a mail merge and I've hit a but of a stumbling block and I was wondering if anyone can help.

 

I need to manipulate the text such that only the first character is displayed for a record. For example if the data brought through was "EDUGEEK" The only data show would be "E".

 

In excel this would simply be LEFT(,1) but I'm trying to work out how to do this in Word. It would also be usefull if anyoine knew of a way to use the Excel command "Find" to find a specific character in a text string, as well. I'm trying to avoid the extra step of flusing it through Excel which complicates things for the end user.