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