Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Displaying a single character.
If the name is in Range("A1") then:
Sub dk() MsgBox Left(Trim(Range("A1").Value), 1) End Sub <Mike Olds wrote in message ,us... Is there a way in Excel to display only the first letter of a name? What I wish to do is to use concatenate to merge last name and first name, but I wish to display only the 1st character of the first name. EggHeadCafe - Software Developer Portal of Choice Excel Reports in ASP.NET 2.0 http://www.eggheadcafe.com/tutorials...in-aspnet.aspx |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Format single character | Excel Worksheet Functions | |||
Excel Web Query not displaying umlaut character correctly | Excel Programming | |||
LEN fuction to leave a single character | Excel Worksheet Functions | |||
Formula for Displaying the First Character of a word | Excel Discussion (Misc queries) | |||
Character/Symbols not displaying correctly in this web forum ??? | Excel Discussion (Misc queries) |