FirstLetter = Left(Name,1)
Will do the job.
--
Best Regards
Leo Heuser
MVP Excel

Followup to newsgroup only please.

skrev i en meddelelse
om...
I have a string variable called NAME. The variable holds a person's
name:

for example NAME = Peter

How do I return the first letter from the string variable NAME(i.e.
P). What string function do I use?

thankyou