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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top