| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
String Variables
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
String Variables
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Not at all clear on use of variables and/or object variables | Excel Discussion (Misc queries) | |||
| Change 3 letter text string to a number string | Excel Discussion (Misc queries) | |||
| How do I string formulas together in Excel to display variables | New Users to Excel | |||
| String variables | New Users to Excel | |||
| to search for a string and affect data if it finds the string? | Excel Worksheet Functions | |||
Linear Mode
