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(<Cell>,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.