String Variables

T

terryspencer2003

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
 
L

Leo Heuser

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

Followup to newsgroup only please.
 
Top